Categories
Software

My Favorite Excel Function: =WORKDAY

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 🔥🔥🔥