Year Month

[ozbeachbum]

Hi,
I have currently the following formula;
=IF(MONTH(F25)<= MONTH(TODAY()),AAM69,0)
I need to modify it to include the YEAR and my efforts to date have been unsuccessful.

 

[AhoyNC]

Try:
=IF(AND(MONTH(F25)<=MONTH(TODAY()),YEAR(F25)=YEAR(TODAY())),"AAM69",0)

 

[Cubist]

Try:

=IF(EOMONTH(F25,0)<= EOMONTH(TODAY(),0),AAM69,0)

If the value of AAM69 is numeric, you can try:

=(EOMONTH(F25,0)<= EOMONTH(TODAY(),0))*AAM69

 

[Phuoc]

A little shorter:

=IF(F25<=EOMONTH(TODAY(),0),AAM69,0)

 

[ozbeachbum]

Thanks to both as each suggestion works.