Forum Discussion
Richard Kirk
Oct 03, 2018Copper Contributor
Age calculation
I have a list of dates of birth from a membership spreadsheet. Is there a formula to give me ages of members against current date? Thanks in advance.
- Oct 03, 2018
HansVogelaar
Mar 19, 2022MVP
DOB should either be a defined name or be replaced with a reference to the cell containing the date of birth.
BP_Russell
Mar 19, 2022Copper Contributor
Thanks for your reply. I designated the current date as "end_date" and the column of birth dates as "start_date" - it did not change the result.
- BP_RussellApr 17, 2022Copper Contributor
HansVogelaar sorry to not respond. I'm in coaching season right now, so had to back-burner this for a few weeks. I will come back around to this in June.
- HansVogelaarMar 19, 2022MVP
Could you attach a sample workbook demonstrating the problem to a reply, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?