Hi,
I hope everyone is doing well in this new year 2023. Well, I am a bit stuck with this idea of hidden reference date against the TODAY function. Actually, I want to display the number of days between a past date and TODAY. However, I want to do this with a date that is not displayed anywhere, but is rather embedded inside the formula; kind of =TODAY()-2022/09/30. Is this possible?
You could use the DATEVALUE function to convert your text to actual date
=TODAY()-DATEVALUE("2022/09/30")
Or tryFormula:
=TODAY()-DATE(2022,9,30)
Mates,
That's great. Thanks a lot. The thing works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks