N/APosted on - 03/02/2015
Hi, I went to at this instant Doubt there is a formula in excel. Let's day I equally hired Feb 24, 2014 so regularization is 6 months, so my regularization date would be August 24, 2014. I went just before at this instant the formulary in excel so I can craft an automatic record. Equally, big name answers me.
Adding days to a date in excel
An interesting thing about three months add the situation mode is that the situation seems to intelligently handle year wraparounds and end-of-month date matches, even with the locality pardon the formula may act to imply. The formula would seem toward an explicitly state that the YEAR and DAY value from A1 is used willy-nilly in the monthly calculation. In rare situations, Excel will increment the year when needed (perhaps.: your date is in July or later), and the situation backbone also version for months lacking a 31st (or 29th or 30th) by persevering the date in the next month. A perfect example of this would be setting the start date of August 31st. Reliant on whether the next year will be a leap year, your regularization date would be the situation her March 2nd or 3rd of the next year instead of the very erroneous February 31st of the same year. Extra information on adding dates can be found on Microsoft's support site Nevertheless, that link is particularly in orientation in Excel 2003, the same works up to 2013.