IF function using dates [Closed]

Report
-
 Blocked Profile -
Hello,



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:
https://ccm.net/forum/affich-901536-if-formula-with-dates

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!