Forum Discussion

Copper Contributor

Jul 28, 2020

Help with formula on due dates

I have a start date (Will always be the end of a month (ex 12/31/2019 or 09/30/2018) and I need the formula to calculate the date 4 months later on the 15th of the month. If the 15th is a weekend then...

excel

Formulas and Functions

Akmcg2

Copper Contributor

Jul 29, 2020

So for example, a person files forms on a fiscal year of 09 (09/30/2019) Per the formula you gave me their items are due 01/15/2020.

Now they filed paperwork on 2/13/20 - I need to know what is the next due date after the date they filed the paperwork. So it would be 01/15/2021. Because the due dates are always 1/15 - just different years because of the fiscal year of 09. Does that make sense?

Akmcg2

Copper Contributor

Jul 31, 2020

HansVogelaar Any ideas??

Akmcg2
Copper Contributor
Jul 31, 2020
Thank you!
HansVogelaar
MVP
Jul 31, 2020
Akmcg2

How about

=WORKDAY(DATE(YEAR(L3)+L5+1,MONTH(L3),14),1)
Akmcg2
Copper Contributor
Jul 31, 2020
This does not return the correct answer

So it’s nots one. I need the year from the date the agreement was dated and then the month it’s due is based off of a different cell

So cell k1 is the agreement date
Cell L3 is the due date

Example: agreement date 2/13/2020
Due date: 10/16/2017

I need a formula that will show the next due date after the agreement date. So with this example the answer should be 10/15/2020.
HansVogelaar
MVP
Jul 31, 2020
Akmcg2

That would be

=WORKDAY(EOMONTH(A2,15)+14,1)