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!

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

"Darin" wrote:

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!