IF function using dates

Joy - Jun 8, 2016 at 11:34 AM
 Blocked Profile - Jun 8, 2016 at 05:02 PM

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 response

Blocked Profile
Jun 8, 2016 at 05:02 PM
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