This is a neat trick to calculate the number of days in a month. I can’t claim any credit for this as I found it on another site (sorry, but I’ve forgotten where), anyway the simple way to calculate the number of days in a month for a given date is:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)
This works by converting [...]

Popularity: 5% [?]

Everybody's a critic (Be the first to rate this post)

 Loading ...