Previous Topic Next Topic

Excel Conditional Formula

Closed
kaustin Posts 3 Registration date Tuesday April 29, 2014 Status Member Last seen April 29, 2014 - Apr 29, 2014 at 10:30 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 29, 2014 at 12:12 PM
Here is my need. I have a visit date that I want to prepare for 3 weeks in advance. So if I have a date of 5/23/14 for the visit I want a cell to show me the date of 5/2/14 as the prep day. However if the visit date has past, I want the date of the visist to be defaulted in this prep date. So for example if the visit date was 1/23/14 I would want the prep date to be 1/23/14.

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 29, 2014 at 11:28 AM
Hi Kaustin,

Try this formula:
=IF(TODAY()>A2,A2,A2-21)

Best regards,
Trowa
0
kaustin Posts 3 Registration date Tuesday April 29, 2014 Status Member Last seen April 29, 2014
Apr 29, 2014 at 12:01 PM
I have a twist. We have three factors to consider. I have a Date that the Visit was scheduled, and I need a date 21 days prior to that date to prep for the visit.=, if that date is less than 21 days then I need to default to the date of request for the visit. Example

Visit request date is 4/23/14, Date of Visit is 5/23/14, Date for Prep Due on 5/2/14
Visit request date is 4/23/14, Date of Visit is 5/1/14, Date for Prep Due on 4/23/14
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 29, 2014 at 12:12 PM
Hi Kaustin,

Then your formula would look like:
=IF(B2-A2>21,B2-21,A2)

Best regards,
Trowa
0
Answer 2 / 2
kaustin Posts 3 Registration date Tuesday April 29, 2014 Status Member Last seen April 29, 2014
Apr 29, 2014 at 11:48 AM
My hero!!!
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses