Date calculations in microsoft excel

Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow.

No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback?

The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. The Excel YEAR function is very straightforward and you will hardly run into any difficulties when using it in your date calculations:. The WEEKDAY function can help you determine which dates in your Excel sheet are working days and which ones are weekend days, and also sort, filter or highlight workdays and weekends:.

Which time interval to use for calculating the date difference depends on the letter you enter in the last argument:. These are just the basic applications of the DATEDIF function and it is capable of much more, as demonstrated in the following examples:. For example, the below formula returns 1 because the week containing January 1 is the first week in the year. This very specific function can be used to solve practical tasks such as calculating age from date of birth.

It automatically excludes weekend days from calculations as well as any holidays that you specify. This function is very helpful for calculating milestones and other important events based on the standard working calendar. For example, the following formula adds 45 weekdays to the start date in cell A2, ignoring holidays in cells B2:B INTL allows calculating a date N number of workdays in the future or in the past with custom weekend parameters.

The DATE function is very helpful for calculating dates where the year, month, and day values are stored in other cells. For example, to find the serial number for the date, taking the values in cells A2, A3 and A4 as the year, month and day arguments, respectively, the formula is:.

In this case, you can use DATE in liaison with other functions to convert a date stored as a numeric string or number into a date:. As already mentioned, Microsoft Excel stores dates as serial numbers and operates on those numbers in formulas and calculations. For example:. The formula adds 15 days to May 20, and returns June 4, The result of the above formula is May 5, , which is May 20, minus 15 days. The formula calculates how many days are between the current date and some other date that you specify.

And here are a few more examples where Excel DATE is used in combination with other functions in more complex formulas:.