Skip to main content

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?