WORKDAY FUNCTION

B

BOB

HOW DO YOU ADD SATURDAYS TO THE WORKDAY FUNCTION?

IN CELL A1 IS THE DATE 6/4/2004

IN CELL A2 IS THE NUMBER 5

IN CELL A3 IS THE FORMULA =WORKDAY(A1,A2)
THE DATE 6/11/2004 APPEARS IN CELL A3

NOW ASSUME THAT YOU WOULD LIKE TO ADD SATURDAY 6/5 TO CELL A3, HOW IS THIS DONE? IN OTHER WORDS AFTER ADDING BACK SATURDAY, CELL A3 SHOULD RETURN THE DATE OF 6/12/2004
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top