Sign in to join the conversation:
=IF(ISDATE(DOB1), IF(MONTH(DOB1) > MONTH(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), IF(MONTH(DOB1) = MONTH(TODAY()), IF(DAY(DOB1) > DAY(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), YEAR(TODAY()) - YEAR(DOB1)), YEAR(TODAY()) - YEAR(DOB1))), "")
Is this a helpful formula, or are you looking for assistance?
If it's the former, thank you as I can see a formula like this being very handy. If it's the latter, then that is properly lazy.
Either way, putting some more detail around what the formula represents would be great.
Kind regards,
Chris McKay
Hi everyone, I have a sheet that has various steps for people to complete. As they complete their task, the date is recorded that it is completed. What I would like to show is most recent date of completed so that I can show the last step completed date and then what the last step completed was (the column title of the…
we have a lot of sheets that users need to enter data and add attachments and the like. what permissions are needed for this? it seems we have some users who are admin - but they don't really need to be. so how are the permissions set to be able to add data to sheets, and remove from being admins?
