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
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.
Related:
- Excel Conditional Formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 29, 2014 at 11:28 AM
Apr 29, 2014 at 11:28 AM
Hi Kaustin,
Try this formula:
=IF(TODAY()>A2,A2,A2-21)
Best regards,
Trowa
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 11:48 AM
Apr 29, 2014 at 11:48 AM
My hero!!!
Apr 29, 2014 at 12:01 PM
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
Apr 29, 2014 at 12:12 PM
Then your formula would look like:
=IF(B2-A2>21,B2-21,A2)
Best regards,
Trowa