Last Day of Month

[Dale Hymel]

I have been using
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) to return the number of days in the month
on Cell A1.

Is there a better way?
Thanks

 

[Vasant Nanavati]

Hi:

You can use the EOM function, but that requires the Analysis Toolpak to be
installed. I prefer to use the method you have described.

Regards,

Vasant.

 

[Dale Hymel]

Looked at EOM, and I think your are right, the below is just as easy. Many
Thanks

 

[Daniel.M]

Hi,

=32-DAY(A1-DAY(A1)+32)

2 Function calls instead of 4 but hey, I don't think your formula will slow down
your spreadsheets ;-)

Regards,

Daniel M.

 

[Vasant Nanavati]

Daniel, how do you come up with these things? Ingenious!

Regards,

Vasant.

 

[Daniel.M]

Dates are fun..

Daniel M.