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

  • Thread starter Thread starter Andy
  • Start date Start date
A

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
 
Think there was a typo

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

--
Regards,
Tom Ogilvy

EZ Money said:
=IF(MONTH(TODAY()=8),D4,"")

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Andy said:
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
Click to expand...
Click to expand...
 
Back
Top