if function with date question

  • Thread starter Thread starter spirosu
  • Start date Start date
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
 
Hi

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

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date question?? 13
Help with a date formula 13
using date function, month shows as January when i type (12) 3
If statement with dates 0
Date Functions 6
Lock Cells Dependent on Prior Months 1
A couple of questions 3
Fixed date with IF-function (or any other ideas?) 2

Back
Top