Excel Conditional Formula [Closed]

Report
Posts
3
Registration date
Tuesday April 29, 2014
Status
Member
Last seen
April 29, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
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 replies

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Kaustin,

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

Best regards,
Trowa
Posts
3
Registration date
Tuesday April 29, 2014
Status
Member
Last seen
April 29, 2014

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
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Kaustin,

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

Best regards,
Trowa
Posts
3
Registration date
Tuesday April 29, 2014
Status
Member
Last seen
April 29, 2014

My hero!!!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!