Excel Date

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