Forum Discussion
Add months in date
Why is the first date the first of the month and all the others the last day of the month?
If you want to round up, why do you want the result for the first date to be the 15th instead of the 16th?
The middle of January is the 16th, not the 15th.
See attached workbook with first date changed to 31-12-2022 for consistency, and a new formula that will work if the dates are all the last day of the month.
I have attached the excel sheet that illustrates what the issue is. Let me know if it still not cleared.
Why is the first date the first of the month and all the others the last day of the month?
If you want to round up, why do you want the result for the first date to be the 15th instead of the 16th?
The middle of January is the 16th, not the 15th.
See attached workbook with first date changed to 31-12-2022 for consistency, and a new formula that will work if the dates are all the last day of the month.