Check if date > todays month

**samz91** · 09-28-2012, 04:17 AM

How to check if a date cell is greater than the 25th of todays month

**Sindhus** · 09-28-2012, 04:21 AM

Try if this formula helps. =IF(Your date>DATE(2012,MONTH(TODAY()),25),True,False)

Regards,
Sindhu

**daddylonglegs** · 09-28-2012, 07:42 PM

Originally Posted by Sindhus

Try if this formula helps. =IF(Your date>DATE(2012,MONTH(TODAY()),25),True,False)

Better not to hardcode the year, I'd say

=Date>TODAY()-DAY(TODAY())+25

**Pepe Le Mokko** · 09-28-2012, 04:25 AM

A little shorter

=Your date>DATE(2012,MONTH(TODAY()),25)

will also return TRUE or FALSE

**Richard Buttrey** · 09-28-2012, 04:36 AM

...and if a generalised solution is required whatever the month

Formula:



=DAY(TODAY())>25

**moses125** · 09-28-2012, 05:17 PM

How about if i want to calculate each time a date listed in Column H falls with in the month of September?

**Richard Buttrey** · 09-28-2012, 07:36 PM

=month(h1)=9

Re: Check if date > todays month