![]() |
#1
|
|||
|
|||
![]()
Can I use Today() function in between a string using &-s in between and get the right date format?
="Todays date is"&TODAY() this is returning Todays date is 40520 But I need like this. Todays date is 12/08/2010 |
#2
|
||||
|
||||
![]()
Instead of writing one formula u can write multiple formula and then concatenate it, so that the date won't get converted into number. The formula in COLOUMN F needs to be written first in accordance with the number mention and afterwards the main formula than u needed. Go through the sample attachment for reference.
|
#3
|
|||
|
|||
![]()
Thanks Nirik. This gives me an idea how to go about. Thanks
![]() |
#4
|
||||
|
||||
![]()
Or use:
Code:
="Todays date is "&TEXT(TODAY(),"mm/dd/yyyy") |
#5
|
|||
|
|||
![]()
Hi,
here is another solution for a formula: ="Today's date is "&TEXT(TODAY();"DD/MM/YYYY") (you must only check that this date format is correct for you, I can't check it because I use Swedish date formats). Kind regards Bjorn |
![]() |
Tags |
date, format, today |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to make the task starts next day if no time enough today(task can not be split) | duraid | Project | 1 | 10-25-2010 08:31 AM |
Creating an Auto-Calc'd Date? Today+7 Days? | SoCalTelephone | Word | 0 | 10-06-2010 10:27 AM |