| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changed DOB to age, but if no DOB need cell to be empty.
Gary''s Student wrote:
Try this: "=IF(A1="""","""",DATEDIF(A1,TODAY(),""y"")&"" years, ""&DATEDIF(A1,TODAY(),""ym"")&"" months, ""&DATEDIF(A1,TODAY(),""md"")&"" days"")" just be careful of the text wrapping. If you are really Gary's Student, Gary did an excellent job! Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format changed when the details in cell changed | Excel Worksheet Functions | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
Hybrid Mode
