IF function using datesClosed

Question

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"

ac3mark · Answer

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

IF function using dates

1 response

Similar discussions

Subscribe To Our Newsletter!