Think I can explain this without adding a file. Current version is Office 365
Cell A1 is todays date, Cell A2 is 14 days after today. File set such that whenever it is opened, regardless of the date, A2 is always 14 days later than the date you opened it. Example
A1 =TODAY()
A2 =A1+14
A1 10/24/23
A2 11/7/23
Now, I want to add text to A2 to say something like "Due by". So I modified the cell A2 to ="Due by " &A1+14. What I get as a result is this:
A1 10/24/23
A2 Due by 45237
I can not figure out how to get the cell to show the correct date in A2. Any thoughts?
Bookmarks