Last day of the month
 

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

Last day of the month
 

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

Last day of the month
 

=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)

"Manos" wrote in message
...
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

Last day of the month
 

Thank you

"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