View Single Post
 
Old 04-05-2020, 11:29 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Hi

In attached file is an example how I'd do this (if I understood correctly what you did want to do). I added an optional column where birth date (NB! Not Birthday!) is calculated too.

User has to follow a simple rule (all years less than 1930 must be entered with full year number). When it is too difficult for user(s), then it will be best to make full year number mandatory (i.e. set up data validation rule which restricts entering year numbers less than 1900). With all other solutions you'll risk to err with century for year range 0-29.
Attached Files
File Type: xlsx Age.xlsx (11.6 KB, 6 views)
Reply With Quote