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