Counting Days Formula

[DyingIsis]

Hello Everyone -

First, super thanks for the assist.

Second, my problem.

I'm trying to find a formula that helps me to count the days to a target date and then counts the days since the target date.

Meaning, if I want to count the number of days from today until my birthday in May (for example), I would like the output of the formula to be a negative number. (The negative number would tell me that it is before my birthday.)

If it is now June, and I use the formula to count from my birthday, it would tell me how many days have passed since my birthday. (The positive number would tell me that it is my birthday has passed.)

I have set up a table in which Column A has target dates. I would like a formula to live in Column B that tells me which rows are not yet to the target date based on today's date and which rows are past the target date based on today's date.

Any help would greatly be appreciated.

Thanks for your time.

- DyingIsis

 

[AlphaFrog]

Put this in B1 and copy it down column B. Make sure you format column B as "General". Excel will try to automatically format it as a Date because the formula contains dates.

=Today()-A1

 

[DyingIsis]

Ah, THANK YOU!!!