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.