| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using TODAY function to return a date as text
I need to enter today's date in a formula in the following format:
"12/19/2006". I would like this formula to update automatically with the current date. When I enter TODAY(), in my formula, I get a #REF! error. I suspect that the reason why I get this error is that TODAY() is returning the date in the serial date format. I have tried referring my formula to another cell that contains the formula =TODAY(), with date formatting for the cell, but that doesn't work either. Does anyone have a suggestion for using TODAY() to return a value as text? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using TODAY function to return a date as text
Maybe this........
=TEXT(TODAY(),"mm/dd/yyyy") Vaya con Dios, Chuck, CABGx3 "GH" wrote: I need to enter today's date in a formula in the following format: "12/19/2006". I would like this formula to update automatically with the current date. When I enter TODAY(), in my formula, I get a #REF! error. I suspect that the reason why I get this error is that TODAY() is returning the date in the serial date format. I have tried referring my formula to another cell that contains the formula =TODAY(), with date formatting for the cell, but that doesn't work either. Does anyone have a suggestion for using TODAY() to return a value as text? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need Function to look up value and return a text value? | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Create a function to return text if two logical functions are true | Excel Worksheet Functions | |||
| Today() or Date() function help | Excel Discussion (Misc queries) | |||
Linear Mode
