Results 1 to 2 of 2

Thread: workday with if function

  1. #1
    Neophyte mandoossee's Avatar
    Join Date
    Aug 2020
    Posts
    1
    Articles
    0
    Excel Version
    365

    workday with if function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Can you please help with formula for :

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

    Thanks

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,805
    Articles
    0
    Excel Version
    O365
    Not hard

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •