Excel Tips: Calculation & Formulas > Date & Time

Calculate Age

How to calculate age before 1/1/1900 in Excel?

How to calculate age from birth of date in Google sheet?

How to calculate age from ID number in Excel?

How to calculate age in years and months and days from date of birth in Excel?

How to calculate age on a specific or future date in Excel?

How to calculate next age of a person’s birthday in Excel?

How to convert birthdate to age quickly in Excel?

Calculate Date Difference

How to calculate date/time overlap in days or hours in Excel?

How to calculate days hours and minutes between two dates in Excel?

How to calculate days left in month or year in Excel?

How to calculate days left until deadline in Excel?

How to calculate days until next birthday in Excel?

How to calculate elapsed time/days/months/years between two datetimes in Excel?

How to calculate elapsed years, months, or days from a certain date in Excel?

How to calculate interval days/weeks/months/years between two dates in Excel?

How to calculate number of days in a month or a year in Excel?

How to calculate number of working days left in current month in Excel?

How to calculate quarter and year from date in Excel?

How to calculate the employee tenure in months or years in Excel?

How to calculate the length of service from hire date in Excel?

How to count / calculate quarters between two dates in Excel?

How to count / calculate weeks / months / years between two dates in Excel?

How to count days between two dates including start date in Excel?

How to count number of leap years between two dates in Excel?

How to count the days excluding Sundays between two dates in Excel?

How to count the number of days / workdays / weekends between two dates in Excel?

How to count the number of days except Sunday/weekends in Excel?

How to count the number of days or workdays in a month in Excel?

How to count the number of weekends/weekdays between two dates in Excel?

Calculate Time Difference

How to calculate date/time overlap in days or hours in Excel?

How to calculate days hours and minutes between two dates in Excel?

How to calculate elapsed time/days/months/years between two datetimes in Excel?

How to calculate hours between times after midnight in Excel?

How to calculate hours worked and minus lunch time in Excel?

How to calculate net work hours between two dates excluding weekends or holidays in Excel?

How to calculate time difference between two times or dates?

How to calculate time difference with milliseconds in Excel?

How to calculate working hours per month in Excel?

How to check if time difference greater than a specific time?

How to convert time difference between two times to number (hours/minutes/seconds) in Excel?

How to count number of half hour intervals in Excel?

How to count or calculate hours worked between times in Excel?