I 'm working on something for kids - using excel/macros - and part of it will calculate their ages in days.  I can manage this calculation ok.

Because they're quite young, I'm not sure they will have the ability to enter their dates of birth correctly and thought if they could enter date, month and year in individual cells, there would be a smaller chance of mistakes.

Is there any way of combining the data of the d, m, and y celss into one cell where it can then be read as an actual date and subtracted from today's date?

Thanks for any support