Calculating the Difference Between Two Dates

Hello,

I need one formulae which only says 1 or 0, TRUE or FALSE.

If the Request came 1 day after Created Date - say Yes (1), otherwise No (0).
If the Request came 2 days after Created Date - say Yes (1), otherwise No (0).
If the Request came 3 days after Created Date - say Yes (1), otherwise No (0).


Thank you 😊

Does this do what you want? Put this formula in cell C2 and copy it across to cell E2, then copy those three cells down to the bottom of your data...

=$B2-$A2=COLUMNS($C:C)

I think this modified version of my formula should do what you want...

=$B2-$A2=COLUMNS($C:C)-($B2=$A2)

emm, nope!

A4 and B4 is the current case on my attachment where Created Date is same as the Request Date.
There C4 should be TRUE as well ://

This way we loose no data, because if we only calculate the next day, 2 days after and 3 days afer.. we loose what we have on the current day of Created!!
This is why Request 1st day should take them both, Created date and 1 day after..

Hope I'm clear :§

Originally Posted by EHH

A4 and B4 is the current case on my attachment where Created Date is same as the Request Date.
There C4 should be TRUE as well ://

On the sample worksheet you posted in Message #1, A4 contains 8/25/2019 and B4 contains 8/28/2019... those are not the same date. As a matter of fact, none of the date combinations on the worksheet you posted start and end on the same date. I added one and the modified formula I posted seemed to work correctly for all of the example dates. Can you post a new example worksheet using my formula in Columns C:E and then show what you expected the result to be in Columns F:H so I can see what you are referring to?

My mistake, I apologize.

This one highlighted with green is an ex. This should say TRUE to the Request 1st day too (there we take the current day of Created date, and one day after)!

Thank you for your help !! I appreciate it

Originally Posted by EHH

This one highlighted with green is an ex. This should say TRUE to the Request 1st day too (there we take the current day of Created date, and one day after)!

No, it should not say TRUE anywhere on that row as the two dates are not the same... the one in cell A5 is 9/30/2019 and the one in cell B5 is 8/30/2019.

Gosh!!
Now I see I'm super tired. I have all day trying to figure this out, now I cannot even see!!

Please edit it to same dates, 30.08.19 Created Date and Request Date as well... and help me out, make it apper there TRUE please

I am very sorry!

I have an excel of 17 sheets, with like 800 formulas all linked to the first Sheet!! So all of the results are gonna come up there together on diagrams and stuff..
It makes me go crazzy bcuz I don't know much about excel!!

Originally Posted by EHH

Please edit it to same dates, 30.08.19 Created Date and Request Date as well... and help me out, make it apper there TRUE please

Did you try my modified formula that I posted in Message #4 on it (after correcting the dates to be the same)? I am pretty sure it works the way you want.