Lumbungimgmz4

Formula Excel add months to date =EDATE(start date, number of months) (See screenshots and example below) Example of adding months to date Follow the steps below to perform this procedure on your own Step 1 Ensure the starting date is properly formatted – go to Format Cells (press Ctrl 1) and make sure the number is set to Date Step 2 Microsoft Excel has several functions that allows manipulation of date and time, and one of them is MONTH(), which returns the month of a date in number ranging from 1 (for January) to 12 (December) Some Microsoft Office Excel users may prefer the month to be shown or displayed as month name in text instead of number, in the form of January, February, MarchMETHOD 1 Convert month name to number EXCEL = MONTH (1&B5) The formula returns the number of the specified month Inserting 1 in front of the month name, through the use of the & symbol, allows Excel to recognise the month as a date This concatenation is captured in the Excel MONTH function to co...