Excel - IF Function Problem - Expert Solution

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.

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.