|
|
|
|
#1
04-06-2020, 03:26 PM
|
||||
|
||||
Thanks Bob and Arvi. I'm sorry for not attaching a sample sheet on which the readers could try and find a solution to my request. The IF formula required a helper column but it's okay. BTW I added IF birth year is 2000, 2000.
I will try the validation list and file it for future reference. I filtered those years below 1930 and retyped the 4 digit years. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Default How to automatically Calculate number of days between two dates? | wcngu1 | Word | 6 | 10-24-2019 04:20 AM |
| Calculate time over two dates | Diver | Excel | 3 | 07-22-2017 11:31 PM |
| Is this possible? - Calculate and Display the date range between 2 specific dates | Premier-UK | Excel | 2 | 08-18-2014 05:43 AM |
 IF Formula to calculate dates
|
Sophie1 | Excel | 2 | 04-23-2014 07:19 AM |
| How to change number format of dates | ketanco | Project | 1 | 09-11-2012 02:34 PM |
Windows 7 32bit 
Office 2013
Hybrid Mode