Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Based on date of arrival 1/20/19 I need a formula that will choose only even months following the date of arrival. Based on this information: If next even month is greater than 1 month up to 3 months from arrival date than soonest even month is chosen If arrival date is less than 4 weeks from next even month than use the following even month (ie. MARCH 2019 is the month that needs to be chosen for the above date of arrival)
Solved by S. B. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 01/02/2018 - 03:16
User 01/02/2018 - 03:16
Excelchat Expert 01/02/2018 - 03:16
User 01/02/2018 - 03:16
User 01/02/2018 - 03:18
Does my problem make sense?
Excelchat Expert 01/02/2018 - 03:19
Can you explain based on the example you have given
User 01/02/2018 - 03:20
So if a person arrives on 1/20/19 they will have a meeting not if February (even month) because that is too soon from date of arrival. Instead the meeting will be April.
User 01/02/2018 - 03:22
If the date of arrival is 12/20/18 there will be a meeting on the first even month after their date of arrival which is February​
Excelchat Expert 01/02/2018 - 03:23
Excelchat Expert 01/02/2018 - 03:23
So what is the minimum duration needed?
User 01/02/2018 - 03:23
1 month
User 01/02/2018 - 03:23
max is 3 months
Excelchat Expert 01/02/2018 - 03:23
Hmm ok
User 01/02/2018 - 03:35
Is this a difficult one?
Excelchat Expert 01/02/2018 - 03:35
Wait a bit
User 01/02/2018 - 03:36
no problem
Excelchat Expert 01/02/2018 - 03:41
Will you take the duration as 28 days? For example if arrival is 3/2/19
Excelchat Expert 01/02/2018 - 03:42
what should be the output?
User 01/02/2018 - 03:42
JUNE would need to be the output
Excelchat Expert 01/02/2018 - 03:43
So you are setting 30 days duration
User 01/02/2018 - 03:43
User 01/02/2018 - 03:44
thats the minimum
Excelchat Expert 01/02/2018 - 03:46
[Uploaded an Excel file]
Excelchat Expert 01/02/2018 - 03:46
The formula is in B5
Excelchat Expert 01/02/2018 - 03:46
enter your date in B3
User 01/02/2018 - 03:48
I changed the date to 9/1/17 and #N/A was given
Excelchat Expert 01/02/2018 - 03:50
Here, corrected
[Uploaded an Excel file]
Excelchat Expert 01/02/2018 - 03:52
let me know if this works?
Excelchat Expert 01/02/2018 - 03:52
or any problems?

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