# Excel Date - Free Excel Tutorial

## How to Sum if Date Between Two Dates in Excel

In previous article, we have introduced you the method to sum if by year, you can check “How to Sum Data if by Year in Excel” on our website for reference. But sometimes we may want to sum numbers not for a year but just for a period. In this article, we will show you… read more »

## How to Count Cells between Two Dates or Times in Excel

This post will guide you how to count cells between two dates using a formula in Excel 2013/2016. How do I count times between a given time or date range based on a condition in Excel. Is there a easy way to count cells between two given dates in a selected range of cells in… read more »

## How to Generate Random Date in Excel

In some special situations we may need to generate some random dates in worksheet. We can enter date manually, but if we want to require a lot of random dates, we will spend a lot of time on manual entry, and this work is very boring. Above all, we need to find out a quick… read more »

## How to Sum Values Based on Month and Year in Excel

We often do some summary or statistic at the end of one month or one year. In these summary tables, there are at least two columns, one column records the date, and the other column records the sales or product number or total costs etc. If we want to calculate the total values based on… read more »

## How to Convert Text to Time in Excel

This post will guide you how to convert time string to time in Excel. Assuming that you have a list of text string in your worksheet, and you wish to convert these time string to standard time format, how to do it. You need to use an formula based on the TIMEVALUE function, the LEFT… read more »

## How to Calculate Remaining Days in a Month or Year in Excel

This post will guide you how to calculate remaining days in a given month or year in Excel. How do I calculate the number of days left in a month or year using a formula in Excel 2013/2016. Calculate Remaining Days in a Month Calculate Remaining Days in a Year Calculate Remaining Days in a… read more »

## How to Convert mmddyy to Date in Excel

This post will guide you how to convert non-standard date formats or text to a standard date in Excel. If you have a date with mmddyy format, and you want to change it as the normal date format as mm/dd/yyyy with Excel Formula. How do I convert the mmddyyyy text to normal date format in… read more »

## How to VLOOKUP to Return Value if Date Falls between Two dates in Excel

This post will guide you how to do a VLOOKUP between two dates and return corresponding value in Excel. How do I VLOOKUP between two dates and return corresponding value with lookup formula in Excel. How to lookup a value if the date fall between two dates in Excel. VLOOKUP Value If Date Falls between… read more »

## Convert Excel Date to Unix Time Stamp (or Time Stamp to Excel Date)

This post will guide you how to convert a date string to a Unix time stamp in Excel. How do I convert excel date to Unix timestamp with a formula in Excel. How to convert Unix time stamp to an excel date string in Excel. Convert Excel Date to Unix Time Stamp If you want… read more »

## Converting Week Number to Date

This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get week number from a given date with formula in Excel. Convert Week Number to Date… read more »

## Convert Month Name to Number

This post will guide you how to convert month name to number in excel. How do I convert month name to number with an excel formula. How to convert month name to number with an Excel VBA macro. How to convert 3 letter month abbreviation to number in excel. How to convert 3 character month… read more »

## Get the First Monday of a Given Year

This post will guide you how to get the first Monday of a given year or date in excel. How do I calculate the first Monday of a specific year in excel. How to determine the first Monday in a given year date with a formula in excel. How to find and get the date… read more »

## Calculate Thanksgiving Date

This post will guide you how to calculate the thanksgiving data based on a specific year date in excel. How do I get the thanksgiving date based on a specific years in excel. Calculate the US Thanksgiving Date You can use a simple arithmetic to calculate the possible date range for the US Thanksgiving, it… read more »

## Excel WORKDAY.INTL Function

This post will guide you how to use Excel WORKDAY.INTL function with syntax and examples in Microsoft excel. Description The Excel WORKDAY.INTL function returns the serial number of the date before or after a specified number of workdays. And this function allow you to exclude weekends and holidays as non-working days. You can use the… read more »

## Excel WORKDAY Function

This post will guide you how to use Excel WORKDAY function with syntax and examples in Microsoft excel. Description The Excel WORKDAY function returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified. So you can add a specified number of… read more »

## Excel WEEKNUM function

This post will guide you how to use Excel WEEKNUM function with syntax and examples in Microsoft excel. Description The Excel WEEKNUM function returns the week number of a specific date, and the returned value is ranging from 1 to 53. And this function will start to count the week number from January 1 and… read more »

## Excel WEEKDAY Function

This post will guide you how to use Excel WEEKDAY function with syntax and examples in Microsoft excel. Description The Excel WEEKDAY function returns a integer value representing the day fo the week for a given Excel date and the value is range from 1 to 7. so you can use this function to get… read more »

## How to Combine 3 Cells to Generate One Date

This post explains that how to create a date from 3 different cells in excel. How do I combine 3 general cells to one date cell using excel formula. Assuming that you have a list of data that contain three columns of data naming: year, month and day. You want to generate a date from… read more »

## How to Add / Subtract Days, Months and Years to Date

This post will guide you how to add or subtract a given number of days to a date in excel. How to add or subtract weeks to a date using excel formula. How to add or subtract a certain number of months to a date using excel formula. How to add or subtracts a given… read more »

## How to Convet Text Date dd/mm/yy to mm/dd/yyyy as Date Format

This post explains that how to convert text date in the format dd/mm/yy to the standard date format mm/dd/yyyy in excel. How to change dates in text format dd/mm/yy to mm/dd/yyyy as date format in excel 2013. Convet Text dd/mm/yy to mm/dd/yyyy as Date Format If you want to convert dates in the text format… read more »

Sidebar