Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc