I needed to generate dates of birth for some testing recently and found that this was an easy way to do it. Excel ensures that you don’t get any invalid dates (such as 31st of February, or Leap Year problems).
In this spreadsheet you enter the ages that you’d like your test data to represent, e.g 18-75, 30-40 and the spreadsheet does the rest.
Click here to download the spreadsheet.
