if function with date question

S

spirosu

I was wondering how I can write an if function targeting a specific dat
every month.

What I want to do in essence is when the 20th of every month comes by
to write a certain value, if it's not the 20th, leave the cell empty.

I was trying variations of this:

if(a1=20-mmm,"500","")

...of course to no avail

any ideas? thanks in advance for your help
 
H

Harald Staff

Hi

=IF(DAY(A1)=20,500,"")
or volatile
=IF(DAY(TODAY())=20,3,0)

HTH. Best wishes Harald
 
Top