Hi Everyone, there was a time when I could have figured this out, but now I cant even remember what I had for lunch yesterday... I am using the most current version of Office 365 in Windows 10. I need to be able to know how many more days I have left to complete a project. In cell A1 in have the number of days allowed to complete the project. In cell A2 I have the start date. I would like to be able to figure this out with no end date. Here is the formula I have been toying with, but I can't get it to work. Any help at all is greatly appreciated. Below is the formula have been trying to use.
=MAX(A1-(A2-TODAY()), 0)
=MAX(A1-(A2-TODAY()), 0)