I am using the function TODAY(). The date is in a custom format of YYYYMMDD. How can I take this date and use it as it appears without converting it to Julien format?
I am using the function TODAY(). The date is in a custom format of YYYYMMDD. How can I take this date and use it as it appears without converting it to Julien format?
Are you completely averse to using a helper column to convert your custom format to a standard one then calculating off of that? You could always hide the helper column afterwards so your custom format would be the only visible one.
No. That would be fine. I just need to be able to take the format provided for today() and use if for pulling cells from other worksheets so a helper cell could do the trick. What would the steps be?
Not sure I'm understanding exactly what you mean, but take a look at the attached file. I'm converting dates (including "=TODAY()) too and from your custom format, the idea being you can use that converted value in your calculations.
Your custom format to standard date =TEXT(A3,"0000-00-00")
Standard format to your custom format =TEXT(A2,"yyyymmdd")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks