I am trying to make a sheet with due dates that are based on date of enrollment into our program and fiscal year

The date of enrollment is in cell K2.
The paperwork we have to complete is due by Sept. 30th each year thereafter.  
Our fiscal year is Oct. 1 - Sept. 30 each year.

I have figured out all due dates when based on 30 days, 3 months, 6 months etc... but I want staff to see when something is due at the end of the year with an actual due date so it can be checked off when completed.
Angie McCarthyAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
You can fill first date with this formula:
=DATE(YEAR($K$2),9,30)
next:
=DATE(YEAR($K$2) + 1,9,30)
etc.
Early-Head-Start-Tracking-Form.xls.xlsx
0
 
als315Commented:
Can you upload sample worksheet and show expected result?
0
 
Angie McCarthyAuthor Commented:
Sure thing!

I am needing the Annual things to populate the due date (which would be Sept. 30th of the following year from sign date K2).  And then the next year and the next year.
Does that make sense?  I am having such a tough time with this! LOL
I would appreciate ANY help I could get :):)
Early-Head-Start-Tracking-Form.xls.xlsx
0
 
Angie McCarthyAuthor Commented:
You are AMAZING! Thank you, thank you, thank you!  I had been searching and trying different formulas for HOURS!
This is very much appreciated!
0
 
als315Commented:
You are welcome.
Do not forget to close question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.