insert a date on A1 and use this formula


=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

hth
regards from Brazil
Marcelo

"Jay" escreveu:

Hey guys:

Just a quick question; "Is there a formula calculation for getting the last
day of the current month regardless of when in the month the file is opened?
I'm sure there is such a thing, I just need a little help from the guru's!

Thanks.