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
APRIL IS THE ANSWER FOR 1/20/19 not MARCH
User
01/02/2018 - 03:16
Sorry
Excelchat Expert
01/02/2018 - 03:16
Hi
User
01/02/2018 - 03:16
Hi
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
Ok
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
yes
User
01/02/2018 - 03:44
thats the minimum
Excelchat Expert
01/02/2018 - 03:46
check
[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.