Help with IF Statement using dates

[Mldeuser]

I am trying to write an IF statement where if cell G1 = 1st day of the month and cell H1 = the last day of the month then do the following otherwise go to the next if statement.

My problem is how to account for months ending on the 28th 29th for leap year the 30th and the 31st.

Any suggestions would be greatly appreciated.

Thank you

 

[T. Valko]

I am trying to write an IF statement where if cell G1 = 1st day of the month and cell H1 = the last day of the month then do the following otherwise go to the next if statement.

My problem is how to account for months ending on the 28th 29th for leap year the 30th and the 31st.

Any suggestions would be greatly appreciated.

Thank you

Try something like this...

Assuming the cells will contain dates only (or they could be empty).

=IF(AND(DAY(G1)=1,H1=EOMONTH(G1,0)),...

Note that the EOMONTH function requires the Analysis ToolPak add-in be
installed if you're using a version of Excel prior to Excel 2007. If you enter the formula and get a #NAME? error look in Excel help for the EOMONTH
function. It'll tell you how to fix the problem.

 

[njimack]

=IF(AND(DAY(G1)=1,DAY(H1+1)=1),"Yes","no")

 

[Mldeuser]

That worked thank you

 

[T. Valko]

That worked thank you

You're welcome. Thanks for the feedback!