Excel Magic Trick 372: WORKDAY function - Find Date in Future

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
7,014
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 27, 2009

See how to find the school evaluation end date with the WORKDAY function given a start date, number of workdays and non-included days. See how to have a dynamic range using the Excel List (2003) or Excel Table (2007) feature.

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (11)

Sign In or Sign Up now to post a comment!
  • You are welcome!

  • Thanks it helped for stock sales. The table also helped to copy and paste without changing the holidays. Nicely done

  • I do not have any videos on scheduling. If you have a specific Excel question you might try posting it to the Mr Excel Message Board:

    mrexcel[dot]com/forum

    THE smartest Excelers in the world hand out at this site.

    I made a video about this siye. If you search YouTube for "Post Question at Mr Excel", you will find the video.

  • hi mike,

    i just started a new job and i was asked to schedule a roster for employees for 2010. Is there any video that you teach on this? please advise if I can use excel for this? I would greatly appreciate your input.

    Thanks

    Binoj

  • I don't understand. If you are given 11/30/2009 (Mon), you arleady have the date.

  • How do I determine the Monday date of the week does the given date belong to ? ex... Monday date of 12/01/2009 (tues) is 11/30/2009 (Mon)....Is there such formula?

  • I am glad that you like it!

  • Nice!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more