still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 782
- Office Version
- 365
- Platform
- Windows
Hi
I'm trying to write an if statement base on a date
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
I'm trying to write an if statement base on a date
VBA Code:
=if(a1="Oct-05",1,"")
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