Excel Tips: Calculation & Formulas > Date & Time

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?

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?