How to Get days between dates in Excel

In this article, we will learn about how to get days between dates in Excel. Excel stores dates as numbers, a simple mathematical formulation expla...

Entering Dates Quickly in Microsoft Excel 2010

In this article, we will learn how to enter dates quickly in Microsoft Excel 2010. With dates formula we can count dates based on if the condition ...

Determining Whether A Worked Shift Was Morning, Afternoon Or Night In Microsoft Excel 2010

In this article, we will learn how to determine whether a worked shift was morning, afternoon or night in Microsoft Excel 2010.   To find a...

Converting Older Dates To The Current Year In Microsoft Excel 2010

In this article, we will learn how to change color numbers based on the value result in Microsoft Excel 2010.   You may have found a scenario in ...

Calculating the Number of Hours per Month Allowing for Daylight-Saving Shifts in Microsoft Excel 2010

In this article, we will learn how to calculate the number of hours per month, allowing for daylight-saving shifts in Microsoft Excel 2010.   ...

Adding a Number to a Formatted Time Value in Microsoft Excel 2010

In this article, we will learn how to add a number to a formatted time value in Microsoft Excel 2010. While preparing reports, you want a formula t...

Calculating the Date of the Nth Specific WeekDay of the Month in Microsoft Excel 2010

In this article, we will learn how to calculate the date of the nth specific weekday of the month in Microsoft Excel 2010. Consider a scenario in whi...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.