Pace MTD with Holidays

[Erkjerk]

Hi,

I have a pace set up for our sales department. The formula I have in place is =E1/DAY(TODAY())*31 for January.

Of course we were closed for the 1st so now my pace is off because it is thinking we have worked everyday but really we were off for the 1st. Any idea how I correct it so it subtracts the 1st so the pace is correct? I was also thinking how I would fix it if it is December as well and we miss christmas eve and day. Thanks for the help!

-E

 

[Tom Urtis]

Have you thought about using the NETWORKDAYS function? I posted this image on my blog over 7 years ago so please forgive the outdated appearance, but the function's concept is still the same. See if it works for you by plugging in your dates for any month, after you enter and reference the range of dates that your business is closed for holidays.

 

[Erkjerk]

Interesting idea. I'll give it a try. Thanks for the reply.

 

[Erkjerk]

Have you thought about using the NETWORKDAYS function? I posted this image on my blog over 7 years ago so please forgive the outdated appearance, but the function's concept is still the same. See if it works for you by plugging in your dates for any month, after you enter and reference the range of dates that your business is closed for holidays.

Still unsure how to add the pace formula with the networkdays command. My current one is =E1/DAY(TODAY())*31. Just unsure how to tie that command with it.

 

[Erkjerk]

Nevermind, I got it working now. I just subtracted 1 from the today and it paced correctly.