Last day of the month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manos - 18 Sep 2007 14:56 GMT

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

Reply to this Message

Pranav Vaidya - 18 Sep 2007 15:02 GMT

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

Hope this helps!!

Signature

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

> Dear all
>
[quoted text clipped - 5 lines]
> Any suggestions?
> Thanks in advance manos

Reply to this Message

Bob Phillips - 18 Sep 2007 15:03 GMT

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

Signature

HTH

Bob

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

> Dear all
>
[quoted text clipped - 6 lines]
> Any suggestions?
> Thanks in advance manos

Reply to this Message

Manos - 18 Sep 2007 15:26 GMT

Thank you

> Dear all
>
[quoted text clipped - 5 lines]
> Any suggestions?
> Thanks in advance manos

Reply to this Message