Sign in to join the conversation:
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/18.
=[Column3]1 - TODAY()
where [Column3]1 holds the future date in question.
Nick
Nick,
Thanks for the information and that did the trick.
On my sheet, I have a Planned Migration Date column that has discrete date values for each row. I have another column called "Migration Week Monday" where it determines Monday's date for the associated Planned Migration Date. My formula works well on the sheet up until I use a cross sheet formula to pull in the date value,…
Hello all. I've searched for a solution but have not found one. I am using an index match formula to return an "employee name" based on a "project name" match. The formula returns no match…but there should be. Scenario: I have a sheet which lists projects including: project #, project name, super, etc. I used a formula on…
I have a sheet that has 20 cells that are dates Due and Done for 10 categories. I have an Overdue Week column that I want to show "Yes" if a Due date is prior to current week. I managed to do that, but once one date leads to a "Yes" it never changes even if the task is completed and marked in the corresponding Done cell.…
