Welcome!

Age

How do I create a formula to automatically calculate the age? I currently have this formula:

=(Date of Birth-Current Date)/365.25

Hi Ayanda,

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Thank you Andre.

I will have a look and try to figure it out. Idf I have further questions I will ask

Happy to help!

Let me know how it goes!

publish link for non licenced users in my workspace no longer allows them to tag me or edit
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
Names not emails as titles
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
Set Default Value in Form that is NOT a Dropdown Value
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…