Forum Discussion
Date difference and return TRUE/FALSE
Dear Community,
| DATE A | DATE B |
| 27/6/2020 | 29/6/2020 |
| 1/7/2020 | 29/6/2020 |
I looking for a formula that can substract (DATEA - DATEB) and return false/true if its more than 7 days.
I tried DATEDIFF, but its return some weird date value and there might DATEB will have lower date than DATEA.
Greatly appreciate for the helps.
Best thanks.
if(abs(datediff([Date A],[Date B],Day)) <=7, "Yes","NO")
NickProp28
What is your formula? Should be like:Column = IF(DATEDIFF([Date A],[Date B],DAY)>7,TRUE(),FALSE())Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NickProp28 , Something like this. Change as per need
if((abs(datediff([Date A],[Date B],Day)) <=7) || (isblank([Date A]) ||isblank([Date B]) ), "Yes","NO")
6 Replies
if(abs(datediff([Date A],[Date B],Day)) <=7, "Yes","NO")
Hello,
please can you tell me if this can be adapted for Work Days (Mon-Fri) only?
many thanks
NickProp28
What is your formula? Should be like:Column = IF(DATEDIFF([Date A],[Date B],DAY)>7,TRUE(),FALSE())Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Anonymous amitchandak ,
Appreciate for the solution. It works perfectly for me.
May I ask, what should be the formula if either one of the Date (DateA/DateB) is blank. I want it return True instead of False.Best thanks.
NickProp28 , Something like this. Change as per need
if((abs(datediff([Date A],[Date B],Day)) <=7) || (isblank([Date A]) ||isblank([Date B]) ), "Yes","NO")
