How do I Make a cell that says "As of Today" and instead of Today pulls the current date MM/DD/YYYY. I haven't been able to add anything to the function Today () to make this work. Does anyone else have a way to do this?
2007-02-26 09:01:28 · 3 answers · asked by Gidgit 1 in Computers & Internet ➔ Software
It is like this
="As of "&TEXT( TODAY(), "MM/dd/yyyy")
Enjoy my profile, I am the VBAXLMan
2007-02-26 20:11:22 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Do you mean excel To Say "As Of Today 02/26/2007" something like that ?
Then just use this formula
="As of Today "&MONTH(TODAY())&"/"&DAY(TODAY())&"/"&YEAR(TODAY())
thats it, copy paste the above formula into the cell and it would work..
If you got any doubts feel free to message me at sam_edwin007@yahoo.com
2007-02-26 10:13:34 · answer #2 · answered by sam e 2 · 0⤊ 1⤋
Try this
="As of today - " & TEXT(TODAY(),"MMM DD YYYY")
2007-02-26 15:00:34 · answer #3 · answered by unnga 6 · 0⤊ 1⤋