I’ve got a long list of data for items purchased by customers, but I want to group the data into categories. How do I do it?
Age calculation in Excel
I am trying to use this syntax =INT((TODAY()-[@DOB])/365) in excel to calculate age in the data I am analyzing. It is giving me year (10/03/1900) instead of an age of that is calculated.
Please, I need an assistant to make it right.