Ravi Sir's Cards › Excel
Birthday and Anniversary Reminder in Excel (card 2 of 2)
Revision card 2 for Birthday and Anniversary Reminder in Excel: Who comes up first: =INDEX(A6:A13,MATCH(MIN(F6:F13),F6:F13,0)) gives Shahrukh; Dates in the next 30 days: =COUNTIF(F6:F13,"<=30") gives 3. Includes an example data table.
Read card text
What this card says
2 for Birthday and Anniversary Reminder in Excel: Who comes up first: =INDEX(A6:A13,MATCH(MIN(F6:F13),F6:F13,0)) gives Shahrukh
Dates in the next 30 days: =COUNTIF(F6:F13,"<=30") gives 3. Includes an
Example
data table
Learn this in the lesson: Birthday and Anniversary Reminder in Excel: Age, Next Birthday and Days Left (DATEDIF)