Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to specific the cell format?
Does anyone know how to do it in excel?
In cell A1, if text within this cell is "Daily", then the cell B1 will show the date in this format "18-Jan". If cell A1, if text within this cell is "Monthly", then teh cell B1 will show the date in this format "Jan-07" Does anyone have any suggestion? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to specific the cell format?
One way:
=TEXT(TODAY(), IF(A1="Daily", "dd-mmm", IF(A1="Monthly", "mmm-yy", "dd mmm yyyy"))) In article , Eric wrote: Does anyone know how to do it in excel? In cell A1, if text within this cell is "Daily", then the cell B1 will show the date in this format "18-Jan". If cell A1, if text within this cell is "Monthly", then teh cell B1 will show the date in this format "Jan-07" Does anyone have any suggestion? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank you for your suggestion
Thank you very much
Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank you for your suggestion
=TEXT(TODAY(),IF(A2="Daily","dd-mm","mm-yy"))
try this too. On Jan 18, 2:51 pm, Eric wrote: Thank you very much Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
Format of a cell | Excel Discussion (Misc queries) | |||
Format cell to accept only specific character-reject others | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |