If today's date is specific month, then . . .

[Andy]

I know this is possible, but I forget how I did it the
last time (!?)

If( [the month of today's date falls in the month of
August] ,D4,"")

I'm trying to do it with the "today()" function, but how
do I get it to select the proper month? Or am I barking
up the wrong tree and there's a better way to do this?

Any/all help appreciated
Andy

 

[EZ Money]

=IF(MONTH(TODAY()=8),D4,"")

 

[Tom Ogilvy]

Think there was a typo

=IF(MONTH(TODAY())=8,D4,"")

--
Regards,
Tom Ogilvy

=IF(MONTH(TODAY()=8),D4,"")

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I know this is possible, but I forget how I did it the
last time (!?)

If( [the month of today's date falls in the month of
August] ,D4,"")

I'm trying to do it with the "today()" function, but how
do I get it to select the proper month? Or am I barking
up the wrong tree and there's a better way to do this?

Any/all help appreciated
Andy