If Function with Date
Hello everyone,
I need a formula that states:
If (d1 (which is a date format) = January 2005,then return b10,if(d1 date =
February, then return b11,otherwise return 0)).
I have tried several ways, my formula does not seem to acknowledge the date
value. What am I doing wrong?
Any suggestions?
Thanks
|