# 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

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
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
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
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!!!