workday with if function

mandoossee

New member
Joined
Aug 15, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
365
Hi,

Can you please help with formula for :

If cell B is empty then today, else find workday between cell A and B.

Thanks
 
Not hard

=IF(B2="",TODAY(),WORKDAY(A2,B2))
 
Back
Top