# 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.
###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Can you upload sample worksheet and show expected result?
0
Author 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 :):)
0
Commented:
You can fill first date with this formula:
=DATE(YEAR(\$K\$2),9,30)
next:
=DATE(YEAR(\$K\$2) + 1,9,30)
etc.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author 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
Commented:
You are welcome.
Do not forget to close question
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.