Log in
x
or
x
x
Register
x

or

Excel Tips: Calculation & Formulas > Date & Time

Add Hours, Minutes, or Seconds to Time or Date

How to add number of business/working days or hours to a date in Excel?

How to add or subtract hours from a date/time field in Excel?

How to add or subtract times to get hours/minutes/seconds in Excel?

How to add or sum times over 24 hours in Excel?

How to add time with hours/minutes/seconds increments in Excel?

How to convert date time from one time zone to another in Excel?

How to quickly add hours/minutes/second to date and time in Excel?

How to quickly convert UTC/GMT time to local time?

Add Years, Months, Weeks, or Days to Date

How to add days to date including or excluding weekends and holidays in Excel?

How to add number of business/working days or hours to a date in Excel?

How to add number of years months and days to date in Google sheets?

How to add or subtract days, months, and years to date in Excel?

How to add or subtract specific years, months and days(2years4months13days) to a date in Excel?

How to add/subtract half year/month/hour to date or time in Excel?

How to add/subtract weeks to date in Excel?

How to calculate a future date based on a given date in Excel?

How to calculate end date from start date and duration in Excel?

How to calculate expiration dates in Excel?

How to calculate retirement date from date of birth in Excel?

How to increment date by 1 month, 1 year or 7 days in Excel?

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?

Check Date or Time

How to check if a date is public holiday and count days except holidays in Excel?

How to check if time is between two times in Excel?

How to check if time is greater than or less than a specific time in Excel?

How to determine if a date falls between two dates or weekend in Excel?

How to determine if date has passed in Excel?

How to determine/check if date is a weekend in Excel?

How to check if a year is a leap year in Excel?

Return Year, Quarter, Month, Day of Week, or Date

How to calculate Easter date in Excel?

How to calculate quarter start date or end date based on a given date in Excel?

How to calculate the date of Thanksgiving day based on specific years in Excel?

How to calculate week ending date of the given dates/years in Excel?

How to find and get the first Monday of a specific year in Excel?

How to find beginning/start of week by any given date in Excel?

How to find earliest and latest dates in a range in Excel?

How to find first / last day or working day of a month in Excel?

How to find first or last Friday of every month in Excel?

How to find or get quarter from a given date in Excel?

How to find the date of next Monday in Excel?

How to find the date of previous Sunday in Excel?

How to get date of birth from ID number in Excel?

How to get end of month date in Excel?

How to get month from week number and year in Excel?

How to get same or first day of next month based on given date in Excel?

How to get the last business day of previous month in Excel?

How to get week start and end date based on a specific date in Excel?

How to return day of the week from date in Excel?

How to return the previous working or business day in Excel?

How to round / round up / round down time to nearest quarter / half hour in Excel?

How to round date to nearest month in Excel?

How to set date to first of month in Excel?

How to show first or last day of previous month based on given date in Excel?

How to tell/return day of week from date in Excel?

How to calculate / get day of the year in Excel?

Others

How to compare dates if greater than another date in Excel?

How to compare two dates by month and year only in Excel?

How to concatenate year, month and day to date in Excel?

How to convert date to fiscal year/quarter/month in Excel?

How to convert hours to 8-hour work days in Excel?

How to find overlapping date/time ranges in Excel?

How to multiply hours and minutes by an hourly rate in Excel?

How to remove date from date time in Excel?

How to remove time from date in Excel?

How to remove year from date in Excel?

How to round time to nearest hour/minute/second in Excel?

How to sum time and format as hours, minutes or seconds in Excel?