Categories
Software

My Favorite Excel Function: =WORKDAY

This Excel function allows me to quickly create post schedule milestones with natural language expressions.

My new favorite Microsoft Excel function is =WORKDAY because it allows me to quickly create Post Schedule milestones (Rough Cut, Fine Cut, etc) with relatively natural language.

Executive Producers are often able to describe how much time they’ll need to hit deadlines, but frequently don’t have a solid grasp of the effects. For example, I will often be told, “We want six weeks to make our rough cut, the network gets three days to address notes, and then we’ll need five full days to address the network’s notes.”

In the past, creating a post schedule from these instructions was a laborious process. But the =WORKDAY function transforms, “the network gets three days to address notes,” into the formula: =WORKDAY(B7,3). And “we’ll need five full days to address the network’s notes,” becomes: =WORKDAY(B9,5). Learning about this function is without doubt 🔥🔥🔥

1 reply on “My Favorite Excel Function: =WORKDAY”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s