Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Date & time
Work with dates and times: TODAY, EDATE, NETWORKDAYS, DATEDIF, WORKDAY.
25 functions
DATEBuilds a dateDATEDIFDifference in years, months or daysDATEVALUEConverts text to a dateDAYDay of a dateDAYSDays between two datesDAYS360Days between dates on a 360-day yearEDATESame day, months laterEOMONTHLast day of a monthHOURHour of a time (0–23)ISOWEEKNUMISO week numberMINUTEMinute of a time (0–59)MONTHMonth of a dateNETWORKDAYSWorking days between datesNETWORKDAYS.INTLWorking days with custom weekendsNOWCurrent date and timeSECONDSecond of a time (0–59)TIMEBuilds a timeTIMEVALUEConverts text to a timeTODAYToday’s dateWEEKDAYDay of the week as a numberWEEKNUMWeek number of the yearWORKDAYDate after a number of working daysWORKDAY.INTLWorking-day date with custom weekendsYEARYear of a dateYEARFRACFraction of a year between two dates