Delta Date

Hello,
I would like add a formula to add a date delta according a deadline
For example: today 16-JUN-2022, my Deadline = 15-JUN-2022 so delta = +1
Today 16-JUN-2022, My Deadline = 10-JUN-2022. so delta = +6
Could you help me for the formula please
Best Answer
-
There might be a simpler approach but this should work:
=IF(Deadline@row < TODAY(), "+" + (TODAY() - Deadline@row), TODAY() - Deadline@row)
Let me know if that helps!
Thanks.
Answers
-
Give this a try and convert it to a column formula:
=IF(Deadline@row > TODAY(), "", TODAY() - Deadline@row)
This leaves the delta column blank for any rows where the deadline is in the future.
Let me know if that helps!
Thanks.
-
Hi,
Thanks,
Is it possile to have + "X" when late and -"X" if the deadline is in the future?
-
There might be a simpler approach but this should work:
=IF(Deadline@row < TODAY(), "+" + (TODAY() - Deadline@row), TODAY() - Deadline@row)
Let me know if that helps!
Thanks.
-
perfect
Help Article Resources
Categories
Check out the Formula Handbook template!