Date difference and return TRUE/FALSE

[NickProp28]

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.

[amitchandak · Accepted solution]

@NickProp28 

if(abs(datediff([Date A],[Date B],Day)) <=7, "Yes","NO")

[V-pazhen-msft · Accepted solution]

@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.
  

[V-pazhen-msft · Accepted solution]

@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]

Dear @V-pazhen-msft @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.

[amitchandak · Accepted solution]

@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")

[NickProp28]

Dear @amitchandak ,

Many thanks for the prompt reply. 

[amitchandak · Accepted solution]

@NickProp28 

if(abs(datediff([Date A],[Date B],Day)) <=7, "Yes","NO")

[44Bailey]

Hello,

please can you tell me if this can be adapted for Work Days (Mon-Fri) only?

many thanks