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