
New Member

January 2, 2021

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


September 9, 2020

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
1 Guest(s)
