Hello,
I have an Excel worksheet that I use to track when users are due to take one of their training courses. Currently I am manually inputting the date to expire, but what I would like to have is when I put the date in one cell it will output in another cell that it is due to expire a moth from the due date. Does this seem like something that can be done in Excel?
###### Who is Participating?
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.

Distinguished Expert - 2017Commented:
Assuming you have dates in Col A from A2, For Due Dates in Col B, add below formula in B2 and drag down:
``````=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))
``````
Then for Remarks in Col C, add below formula in C2 and drag down:
``````=IF(B2<=TODAY(),"Due For Payment","")
``````
Check in attached, change the range accordingly.
Hope this helps.
Due-Dates.xlsx
1
Distinguished Expert - 2017Commented:
If you want to eliminate blanks, then add below formula in B2 and drag down:
``````=IF(A2="","",DATE(YEAR(A2),MONTH(A2)+1,DAY(A2)))
``````
And below in C2 and drag down:
``````=IF(OR(A2="",B2=""),"",IF(B2<=TODAY(),"Due For Payment",""))
``````
Due-Dates_2.xlsx
2

Experts Exchange Solution brought to you by

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

``````=IF(OR(A2="",B2=""),"",IF(B2<=TODAY(),"Due For Training",""))