Forum Discussion
NickProp28
Post Partisan
Post PartisanDate 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. ...
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")
amitchandak
Super User
Super Userif(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