End of Month question
 

In a cell, I have the current date in format -dd/mm/yyyy-. In the cell
below, I want to automatically insert the text Yes if this is the last
day of the month or No if it isn't.

What's the simplest way to do this?

Thanks in advance. :)


--
Purple_Jack
------------------------------------------------------------------------
Purple_Jack's Profile: http://www.excelforum.com/member.php...o&userid=23884
View this thread: http://www.excelforum.com/showthread...hreadid=375192

Use:
=IF(MONTH(DATE(YEAR(A1),MONTH(A1),DAY(A1))+1)=MONT H(A1),"No","Yes")

or
=IF(EOMONTH(A1,"0")=A1,"Yes","No")

For the second one, you require to enable the Analysis ToolPak (Tools
Addins. Check the box for ATP)

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375192

That works perfectly (and you were very fast too). :)

Thanks a lot.


--
Purple_Jack
------------------------------------------------------------------------
Purple_Jack's Profile: http://www.excelforum.com/member.php...o&userid=23884
View this thread: http://www.excelforum.com/showthread...hreadid=375192

Thanks for the feedback.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375192

Simpler

=IF(MONTH(A1+1)=MONTH(A1),"No","Yes")

--
HTH

Bob Phillips

"mangesh_yadav"
wrote in message
news:mangesh_yadav.1pw7uj_1117537514.6793@excelfor um-nospam.com...

Use:
=IF(MONTH(DATE(YEAR(A1),MONTH(A1),DAY(A1))+1)=MONT H(A1),"No","Yes")

or
=IF(EOMONTH(A1,"0")=A1,"Yes","No")

For the second one, you require to enable the Analysis ToolPak (Tools
Addins. Check the box for ATP)

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375192

Simpler:
=IF(DAY(A1+1)=1,"Yes","No")

Bob Umlas
Excel MVP

"Bob Phillips" wrote in message
...
Simpler

=IF(MONTH(A1+1)=MONTH(A1),"No","Yes")

--
HTH

Bob Phillips

"mangesh_yadav"

wrote in message
news:mangesh_yadav.1pw7uj_1117537514.6793@excelfor um-nospam.com...

Use:
=IF(MONTH(DATE(YEAR(A1),MONTH(A1),DAY(A1))+1)=MONT H(A1),"No","Yes")

or
=IF(EOMONTH(A1,"0")=A1,"Yes","No")

For the second one, you require to enable the Analysis ToolPak (Tools
Addins. Check the box for ATP)

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=375192