Question description:
This user has given permission to use the problem statement for this
blog.
Hello, I have a cell that will have a date in it and depending on that date I need to other cells to change to the next 2 months. ie: Cell one says 8/25/2018 and need cell 2 to change to say September and Cell 3 to change to October. ie: if cell 1 said 9/1/2018 i would need cell 2 to say October and cell 3 to say November. Is this possible
Solved by G. A. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/08/2018 - 05:04
Hello, I understand that you need 2 cells to automatically adjusts its date depending on another cell's date, right?
User
16/08/2018 - 05:04
yes
Excelchat Expert
16/08/2018 - 05:04
Sure, this can be done. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
Excelchat Expert
16/08/2018 - 05:04
May I know which cells has the start date and which cells you want to automatically change?
Excelchat Expert
16/08/2018 - 05:06
Are you still with me?
User
16/08/2018 - 05:07
17 B is start date and needs to change 20 E and 21 E date in 17B being 08/15/2018 and coming out with 20E saying September and 21E saying October
Excelchat Expert
16/08/2018 - 05:08
Do you see the sheet to the right?
Excelchat Expert
16/08/2018 - 05:08
If so, please look at B17, E20 and E21.
User
16/08/2018 - 05:08
yes
Excelchat Expert
16/08/2018 - 05:09
B17 has the start date and E20 and E21 will show the next month and month after.
Excelchat Expert
16/08/2018 - 05:09
You can change the value of B17 to test it out.
User
16/08/2018 - 05:09
that would be perfect. Any date i out in Cell B17 the others would change to the next 2 months
Excelchat Expert
16/08/2018 - 05:09
Yes, you can change it now to test it.
User
16/08/2018 - 05:09
that is perfect
Excelchat Expert
16/08/2018 - 05:09
The formula is in E20 and E21.
Excelchat Expert
16/08/2018 - 05:10
Copy those formula and apply to your file.
User
16/08/2018 - 05:11
OMG you are the bigest help every i have googles this for 3 wees stright
Excelchat Expert
16/08/2018 - 05:11
Glad to be oh help. :)
Excelchat Expert
16/08/2018 - 05:11
Please spread the word about us!
Excelchat Expert
16/08/2018 - 05:11
Would there be anything else that I can help you with regards to the original question?
User
16/08/2018 - 05:12
No that would be it thank you so very muxh
Excelchat Expert
16/08/2018 - 05:12
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert
16/08/2018 - 05:12
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert
16/08/2018 - 05:12
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User
16/08/2018 - 05:13
where do i give you a rating?
Excelchat Expert
16/08/2018 - 05:13
Once you end the session, you'll be given the option to.
User
16/08/2018 - 05:13
ok again thank you so much
Excelchat Expert
16/08/2018 - 05:13
I'd appreciate that.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.