Age Calculation
You can calculate age based on their birthday and today's date. 1 :- Datedif Function :- Calculates the number of days, months, or years between two dates =datedif(start date, End Date, Unit) Unit:- 1. Number of completed year :- Y 2. Number of completed Month :- M 3. Number of completed Days :- D 4. The difference between the days. The months and years of the dates are ignored :- MD 5. The difference between the months. The days and years of the dates are ignored :- YM 6. The difference between the days. The years of the dates are ignored :- YD 2 :- Today Date Function :- Returns the current date. =today() Age Calculation :- (C1 = 10-Mar-1980) Number of Years :- DATEDIF(C1,TODAY(),"y") Number of Months:-DATEDI...