Excel Tips: Calculation & Formulas > Date & Time

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?