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.
=IFERROR(IF([End Date (Projected/Actual)]@row = [Target End Date]@row , 0, IF([End Date (Projected/Actual)]@row > [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row , [Target End Date]@row ) + 1, IF([End Date (Projected/Actual)]@row < [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row…
This is a multi-step question. I have a Client Data sheet. One of the columns is Household Name. I'd like to be able to report various metrics at the household level - as well as the individual person level of the Household. In the screenshot, you'll see the Household Name, the Owner First Name & Owner Last Name columns.…
Hi, I'm currently updating my formula sheet and Im looking for a way to have the "Year" automatically follows the current year. Im using the YEAR(TODAY()) function but its not really working for me.. Appreciate if anyone can kindly advise if I missed out something… Thanks.
