Calculate a date of birth fro an age in days number
- Thread starter jonesy
- Start date
Pecoflyer
Admin Alumnus
- Joined
- Oct 13, 2011
- Messages
- 1,802
- Reaction score
- 1
- Points
- 38
- Location
- Brussels Belgium
- Excel Version(s)
- 2010 on Xubuntu - O365
If nr of days in A1 try =TODAY()-A1
masterswordz
New member
- Joined
- Apr 28, 2020
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Location
- Philippines
- Excel Version(s)
- 2016
Assuming AGE is in A1
Put this formula in B1
=TEXT(TODAY(),"MM/DD/")&VALUE(TEXT(TODAY(),"YYYY"))-A1
Put this formula in B1
=TEXT(TODAY(),"MM/DD/")&VALUE(TEXT(TODAY(),"YYYY"))-A1