Emmanuel Katto Dubai : How to Calculate Age in Years Using the Company Start Date?

[emmanuelkatto24]

Hi everyone,

I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) need to create a field that shows the age of a company based on its start year. I have the startup year, and I’d like to subtract it from the current year to get the company’s age in years. What’s the best way to set up an equation for this calculation that will give a whole number?

Any suggestions or formulas would be much appreciated! Thanks!

Regards
Emmanuel Katto

[Sunny_Singla]

Hello Katto,

It’s easy

1. create field start date
   
   
2. Create equation field
   
   

result is

Regards,
Sunny Singla
ssingla1985@gmail.com
+919855089359