If statement based on date

[still learning]

Hi
I'm trying to write an if statement base on a date

=if(a1="Oct-05",1,"")

A1 is formatted mmm-dd
Oct-05 is typed in as 10/5 and excel defaults to 2020
I get a result of a blank cell
I tried to wriite the if statement using 10/5/2020 instead of Oct-05 but it still doesn't work
I also tried to (with the date in A1) copy and paste >>special>>values

Also, did I use the right icon to "set-off" the if statement?????


mike

 

[jasonb75]

Try using

=if(a1=--"Oct-05",1,"")

Dates are numbers not text, when you enter them in a formula in double quotes the text needs to be converted to a numeric value.

 

[still learning]

Hi Jasonb75,
Thanks, I never saw or knew about using -- in an if statement

Mike

 

[jasonb75]

I never saw or knew about using -- in an if statement

It can be used anywhere that a number in text format needs to be coerced into a proper number.

 

[still learning]

Thanks for the explanation.

mike