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% [?]


Latest Comments