Passing date as text in different format in Excel
Posted on 2011-03-23
I need to take todays date and add it to the end of a function as itself in a separate format, then I need to take the date from a month ago, from 6 months ago, and from 12 months ago and do the same thing. This isn't very clear and is best illustrated with an example.
I have a date:
=TODAY() -> 3/23/2011
I need this date to become a text string in the form of:
which gets added to some text in a function:
Which should result in my final text becoming "TEXT=20110323"
I then need to do this for a month ago and 6 months ago and a year ago.
Right now I create the date =TODAY() in the format yyyymmdd, but when I add this to the end of my string, it becomes 40625, the converted Microsoft date.