| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date label and current date in same cell
I have a worksheet where I want to have the current date with a label in the
same cell. Date: 01/01/2008 I tried ="Date:"&Today() but it just gave me Date:39473. Thanks for any thoughts. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date label and current date in same cell
="Date:"&Text(Today(), "dd/mm/yyyy")
or even formt the cell as "Date:"dd/mm/yyyyy and just enter the date or the date formula -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lost in Microbiology" wrote in message ... I have a worksheet where I want to have the current date with a label in the same cell. Date: 01/01/2008 I tried ="Date:"&Today() but it just gave me Date:39473. Thanks for any thoughts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
