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.
I am trying to make a sheet summary that will give me the average of column "# of Days Open" if column "Date Entered" is equal to the last 180 days.
Ideally what I'm trying to do is take a date in a cell and add 5 months to it. I've looked here to find answers and found multiple options. Everything is giving me an "#INVALID COLUMN VALUE" Here is what I've tried so far =IFERROR(DATE(YEAR(Start@row), INT(MONTH(Start@row) + 5), DAY(Start@row)), DATE(YEAR(Start@row) + 1,…
Hi all! I'm trying to use an index collect formula to reference 3 different name columns, and use a range from another sheet to populate their employee number. I want the employee number to populate based on what is entered into any of these 3 employee name columns. The formula I've been trying is, =INDEX(COLLECT({Non-…
