Specific day of month

[Keiser]

Hey, everyone.

I need a formula that tells me when it's the 20th of each month.

I'm using the now()function in C4 and need the formula in D4 to determine if it's the 20th from that date.

any idea's

regards
Keiser.

 

[dk]

Hi,

You can use the DAY worksheet function to return the day of the month from a date e.g.

=IF(DAY(C4)=20,"It's the 20th!","")