![]() |
|
#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.
|
| Tags |
| date, format, today |
|
|
Similar Threads
|
||||
| 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 |