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

Hope this helps!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Manos" wrote:

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