View Single Post
  #1   Report Post  
taxmom
 
Posts: n/a
Default 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