| 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 | |||
Linear Mode
