View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darin Darin is offline
external usenet poster
 
Posts: 25
Default Using IF Function on Dates

I want to build a formula that says =IF(A1=3/1/2008, # of months worked in
this case equals 10, if not another nested If that will use 4/1/08, etc.) . .
Basically I want the date to kick off the # of months left in the year so I
can calculate expense associated w/ the # of months left.

I tried it but I'm having trouble getting the if to recognize the date.
Thanks for your help!