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:-DATEDIF(C1,TODAY(),"ym")
Number of Day's :- DATEDIF(C1,TODAY(),"md")

Birth date : 10-Mar-1980
Number of Years :      37
Number of Months :       2
Number of Days :       1

Popular posts from this blog

Comments