Using IF Function on Dates

  • Thread starter Thread starter Darin
  • Start date Start date
D

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple if formula 5
Expanding Date formula 1
Sum using more than 6 nested IF functions 3
Calculating time between mulitple dates 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
accepting most recent date across columns 10
Excel Message box with days of month & date. 1
Calculating interest due on late loan payments 1

Back
Top