Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how calculate the date someone had to be born to have a specific a
I am trying o build a formula to calculate the the date someone need to be born in order to have certaing age. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how calculate the date someone had to be born to have a specific a
Hi,
Try this: =DATE(YEAR(TODAY()-A1),MONTH(TODAY()),DAY(TODAY())) where A1 is the age. HTH Jean-Guy "AAlvarez" wrote: I am trying o build a formula to calculate the the date someone need to be born in order to have certaing age. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how calculate the date someone had to be born to have a specific a
If you have the age in years only then you can only get a range. If age as of
today (in years) is in A1 then you can get the latest birthdate by using =DATE(YEAR(TODAY())-A1,MONTH(TODAY()),DAY(TODAY())) "AAlvarez" wrote: I am trying o build a formula to calculate the the date someone need to be born in order to have certaing age. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how calculate the date someone had to be born to have a specific a
=DATE(YEAR(TODAY())-A1,MONTH(TODAY()),DAY(TODAY()))
-- Gary's Student gsnu200705 "AAlvarez" wrote: I am trying o build a formula to calculate the the date someone need to be born in order to have certaing age. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
About calculate months between two date (date function) | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
calculate anniversary of date after specified date | Excel Worksheet Functions |