Hi all, Happy New year. can you help me on this, i want to display the monthly due dates automatically in each column. Example the contract is 6 months and the start date is Jan.31, 2021. and the due date is every 31st day of the month, So when i input 12 months, automatically the 12 columns will display the due dates of each month.
Column A - January 31, 2021
Column B - February28, 2021
Column C - March 31, 2021
Column D - April 30, 2021
Column E - May 31, 2021
Column F - June 30, 2021
Thank you
Hi John,
From what I understand, you should use the EOMONTH formula. Here is the description: eomonth-function.
Now, to be more precise in the answer, you could put a file with the data you encode and tell us which ones should be calculated automatically.
BR,
Lionel
indeed, EOMONTH is the right choice.
Use this in the first cell:
=IF(Column(A1)>B1,"",EOMONTH(A1,Column(A1)))
Drag it to the right.
in A1 there should be the start date, in B1 the number of months.
