**Question description:**

*This user has given permission to use the problem statement for this blog.*

Needing help expressing a date based on date range
If Date = 01 OCT 2017 - 30 APR 2018 + 380 DAYS
If Date = 01 MAY 2018 - 31 JUL 2018 + 270 DAYS
If Date = 01 AUG 2018 - 30 SEP 2018 + 430 DAYS

Solved by E. J. in 14 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
01/02/2018 - 09:09

Hello! Thank you for choosingGot it Pro.

User
01/02/2018 - 09:09

Afternoon,

Excelchat Expert
01/02/2018 - 09:10

If Date = 01 OCT 2017 - 30 APR 2018 + 380 DAYS
If Date = 01 MAY 2018 - 31 JUL 2018 + 270 DAYS
If Date = 01 AUG 2018 - 30 SEP 2018 + 430 DAYS

Excelchat Expert
01/02/2018 - 09:10

These are the three conditions you want to impose on a cell and you want a formula to execute the conditions correct?

User
01/02/2018 - 09:11

Yes correct

User
01/02/2018 - 09:11

given a single date, if it falls under one of those conditions

Excelchat Expert
01/02/2018 - 09:11

Constructing the formula for you

Excelchat Expert
01/02/2018 - 09:12

Does the formula represent range like 01 OCT 2017 - 30 APR 2018

Excelchat Expert
01/02/2018 - 09:12

so if data is between these range , then add 380 days to the date?

User
01/02/2018 - 09:13

That is one condition

Excelchat Expert
01/02/2018 - 09:13

Yeah am asking about that only for a single condition if data falls between a mentioned range then add the corresponding days

Excelchat Expert
01/02/2018 - 09:13

am I right?

User
01/02/2018 - 09:13

correct

Excelchat Expert
01/02/2018 - 09:17

=IF(OR(B1>10/1/2017,B1<4/30/2018),B1+380,IF(OR(B1>5/1/2018,B1<7/31/2018),B1+270,IF(OR(B1>8/1/2018,B1<9/30/2018),B1+430,"")))

Excelchat Expert
01/02/2018 - 09:17

In this formula you need to have the date in B1

Excelchat Expert
01/02/2018 - 09:17

Also make sure to change the format to date for the cell you apply the formula in

Excelchat Expert
01/02/2018 - 09:18

Working for you right?

User
01/02/2018 - 09:18

wonderful.. thanks for the assistance.

Excelchat Expert
01/02/2018 - 09:18

Do you need any other assistance regarding this issue?

User
01/02/2018 - 09:18

question regarding the greater than less than

Excelchat Expert
01/02/2018 - 09:18

Yes please ask

User
01/02/2018 - 09:18

if data is equal to value no change?

User
01/02/2018 - 09:19

guess still works.. awesome

Excelchat Expert
01/02/2018 - 09:19

Do you want that too

Excelchat Expert
01/02/2018 - 09:19

If so I will introduce = besides <,>

Excelchat Expert
01/02/2018 - 09:20

=IF(OR(B1>=10/1/2017,B1<=4/30/2018),B1+380,IF(OR(B1>=5/1/2018,B1<=7/31/2018),B1+270,IF(OR(B1>=8/1/2018,B1<=9/30/2018),B1+430,"")))

Excelchat Expert
01/02/2018 - 09:20

Update to the formula

User
01/02/2018 - 09:20

Thank you

Excelchat Expert
01/02/2018 - 09:20

Do you need any other assistance regarding this issue?

User
01/02/2018 - 09:20

this is perfect.

Excelchat Expert
01/02/2018 - 09:20

Thank you for using GotitPro!
Have a great day ahead
Please participate in the survey in the end!

Excelchat Expert
01/02/2018 - 09:21

You may want to end the session now

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