IF function using dates [Closed]

 Blocked Profile -

I'm trying to write a function that will use an divisions data and turn it into manageable data. They record in their spreadsheet an entry date and graduation date. I need to translate this data into monthly numbers. So I need a formula that says "IF the date is > 01/01/16 and less than 01/31/16 = 1"

1 reply

See if this helps:

Understand, you may need to nest if's (as in =IF(logic_test,IF(logic_test2,true_for_test2,false_fortest2),false_forTest1)

It's kind of fun to do the impossible! -Walter Elias Disney

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!