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!

Using IF Function on Dates
 

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!