Good morning hive mind!
Excel date functions tend to throw me for a loop and I'm sure I'm overlooking something. I'm looking to create a countdown timer. You have your start date, you have your end date, and in a third cell the timer counts down the weeks remaining to your end goal starting from today:
A1: 8/20/2020 (Start Date)
A2: 2/4/2021 (End Date)
A3: ***Weeks remaining from Today***
Formula presently in A3: =TODAY()-(DAYS(EndDate,StartDate)/7)
As I have the formula in A3 presently written, excel returns a result of 44116. I thought flipping the formula to =(DAYS(EndDate,StartDate)/7)-TODAY(), This simply gives the same answer as a negative number.
I assume my current result in A3 is due to how excel recognizes dates as numbers counting up from 1900, as well as a weird interaction between the TODAY() and DAYS functions. I have a feeling that this isn't the right formula at all for this type of operation.
Thanks for any help!
Bookmarks