Count Down Formula

Stephanie Taylor

Hi All,

Does anyone have a formula that will count down to a specific date?

Thank you.

Jon Mark H

Hey @Stephanie Taylor !

Try this:

=TODAY() - [Date Counting To]@row

This will give you a negative number that gets closer to 0 as the day gets closer.

If you want to use positive numbers, just swap the two values.

(replace the "[Date Counting To]@row" with your actual

Let me know if that doesn't work for your purposes or if you need any further help!

-Jon Mark Heaner

Jon Mark H

Hey @Stephanie Taylor !

Try this:

=TODAY() - [Date Counting To]@row

This will give you a negative number that gets closer to 0 as the day gets closer.

If you want to use positive numbers, just swap the two values.

(replace the "[Date Counting To]@row" with your actual

Let me know if that doesn't work for your purposes or if you need any further help!

-Jon Mark Heaner

Stephanie Taylor

Thank you. It has been driving me crazy trying to remember that formula.