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.

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.

Jay wrote:
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.

Hi Jay,

One way would be to use:

=EOMONTH(TODAY(),0)

Regards,
Bondi

=DATE(YEAR(A1),MONTH(A1)+1,0)

HTH
--
AP

"Jay" a écrit dans le message de news:
...
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.