How Excel Handles Dates and TimesUnderstanding date serial numbersEntering datesUnderstanding time serial numbersEntering timesFormatting dates and timesProblems with datesExcel’s leap year bugPre-1900 datesInconsistent date entriesDate-Related FunctionsDisplaying the current dateDisplaying any dateGenerating a series of datesConverting a nondate string to a dateCalculating the number of days between two datesCalculating the number of work days between two datesOffsetting a date using only work daysCalculating the number of years between two datesCalculating a person’s ageDetermining the day of the yearDetermining the day of the weekDetermining the date of the most recent SundayDetermining the first day of the week after a dateDetermining the nth occurrence of a day of the week in a monthCalculating dates of holidaysNew Year’s DayMartin Luther King, Jr. DayPresidents’ DayMemorial DayIndependence DayLabor DayVeterans DayColumbus DayThanksgiving DayChristmas DayDetermining the last day of a monthDetermining whether a year is a leap yearDetermining a date’s quarterTime-Related FunctionsDisplaying the current timeDisplaying any timeCalculating the difference between two timesSumming times that exceed 24 hoursConverting from military timeConverting decimal hours, minutes, or seconds to a timeAdding hours, minutes, or seconds to a timeRounding time valuesWorking with non-time-of-day values
