Last day of the month

[Guest]

Dear all

I have in sheet 1 an input date from a user.
I want to run in another sheet (let's say sheet2) based on that day the last
date of the month in order to make some calculations i need.
eg. input form user in A1 14/03/2002 - to be in B1 31/03/2002

Any suggestions?
Thanks in advance manos

 

[Guest]

use function EOMONTH.
for example, =EOMONTH(Sheet1!A1,0) will return the last day of the month.

Hope this helps!!

 

[Bob Phillips]

=Date(Year(Sheet1!A1),Month(Sheet1!A1)+1,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thank you