Log In
Register
Home
New Member
January 2, 2021
Offline
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
Offline
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
November 8, 2013
Offline
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.
1 Guest(s)
