Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
161
Views
Topic starter
I have a tracking worksheet. I need a formula that will calculate a due date of 15 workdays in B3, based on a date entered in B2, unless there is a date entered in B5. If a date is entered in B5 then B3 will return N/A. I have the formula for calculating the due date (=IF(B2<>"",WORKDAY(B2,15),""), and I know how to enter a formula to see if there is anything entered in cell B5 (=IF(B5<>"","N/A"), but I do not know how to combine the two into one formula. Any help is greatly appreciated.
Posted : 02/07/2024 12:53 pm
Try
IF(B5<>"", "N/A", IF(B2<>"",WORKDAY(B2,15),""))
Posted : 02/07/2024 8:20 pm
I wouldn't use N/A since it's also the way to show an error
Posted : 03/07/2024 1:11 am
