Delta Date

Eric Laitenberger

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

Sing C

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.

Sing C

Hi @Eric Laitenberger,

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.

Eric Laitenberger

Hi,

Thanks,

Is it possile to have + "X" when late and -"X" if the deadline is in the future?

Sing C

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.

Eric Laitenberger

perfect