Previous Topic Next Topic

IF function using dates

Closed
Joy - Jun 8, 2016 at 11:34 AM
 Blocked Profile - Jun 8, 2016 at 05:02 PM
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"
Related:

1 response

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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses