Using IF Function on Dates

[Darin]

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!

 

[Sheeloo]

Use Date(2008,1,3) to test. Syntax is Date(year,month,date)
Better still enter the comparison date into a cell and use that reference
for testing