Ensure the starting date is properly formatted go to Format Cells press Ctrl 1 and make sure the number is set to Date. Excel add months to date EDATEstart date number of months See screenshots and example below Example of adding months to date. If month is greater than 12 Excel adds that number to the first month in the specified year.
Month - an integer representing the month of the year from 1 January to 12 December.
In this example were adding and subtracting years months and days from a starting date with the following formula. If month is less than 1 zero or negative value Excel subtracts the magnitude of that. Add to or Subtract From a Date. Build a formula to multiply the cost by the quantity ordered in the Total with Tax This result should be multiplied by one plus the tax rate on the Stock sheet.