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.
I am using this formula: in Excel 2007
=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months, " & DATEDIF(A1,TODAY(),"md") & " days" will give age. for example if A1 contains: 1/15/1985 the formula will return in A2 21 years, 8 months, 15 days Question: If I don't have a date in A1 what do I need to add to formula to keep A2 blank until a date is added to A1? I would also like to color code the age broke down in ranges birth-4 months, 5-8 months, 9-12 months, 1yr, 2yr,3 yr, 4yr and 5 years old. So that it changes as they age. Is this possible? Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changed DOB to age, but if no DOB need cell to be empty.
=IF(A1="","",DATEDIF())
(your material in the DATEDIF(), of course) -- Gary''s Student - gsnu200810 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
changed DOB to age, but if no DOB need cell to be empty.
I was hoping you would answer becasue it was you who wrote the formula I am
using. Now I'm confused with , do I add this to the orginal formula? If soI am getting a error in doing so. "Gary''s Student" wrote: =IF(A1="","",DATEDIF()) (your material in the DATEDIF(), of course) -- Gary''s Student - gsnu200810 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
changed DOB to age, but if no DOB need cell to be empty.
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. -- Gary''s Student - gsnu200810 "melcook1" wrote: I was hoping you would answer becasue it was you who wrote the formula I am using. Now I'm confused with , do I add this to the orginal formula? If soI am getting a error in doing so. "Gary''s Student" wrote: =IF(A1="","",DATEDIF()) (your material in the DATEDIF(), of course) -- Gary''s Student - gsnu200810 |
#5
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 |