Ravi Sir's Cards › Excel
Birthday and Anniversary Reminder in Excel (card 1 of 2)
Revision card 1 for Birthday and Anniversary Reminder in Excel: Age they turn / years married: =YEAR(E6)-YEAR(D6) gives 12; Days left: =E6-$B$3 gives 7; Age today in full years: =DATEDIF(D6,$B$3,"y") gives 11. Includes an example data table.
Read card text
What this card says
1 for Birthday and Anniversary Reminder in Excel: Age they turn / years married: =YEAR(E6)-YEAR(D6) gives 12
Days left: =E6-$B$3 gives 7
Age today in full years: =DATEDIF(D6,$B$3,"y") gives 11. Includes an
Example
data table
Learn this in the lesson: Birthday and Anniversary Reminder in Excel: Age, Next Birthday and Days Left (DATEDIF)