Calculate End Date | Working Days from Start Date - Excel #Shorts

If you're doing any kind of work estimation of dates like what the end date should be if you have a start date and some given number of days are, you'd think this should be easy. Plug in a start date and the number of days and Excel should figure it out. But what about weekends or holidays? Then you'd think it'll that a PhD to figure it out. But Excel makes it easy with the WORKDAY function. Here's an Excel #shorts video to show you how.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[heesroy]

He just went straigt to the point no BS

[wayneedmondson]

Thanks Doug. Good quick function tip! Thumbs up!!

[Snowjk]

I've been looking for this formula and can't seem to find it anywhere so hoping you can help. We have a bunch of employees that we need to grandfather into a PTO plan and the only way is to backdate their PTO start date. So if their real start date is 6/20/2022 and I need to give them 10 years of service, then I need to backdate their start date to 6/20/2012. I'm looking for a formula that would give me that 6/20/2012 date. Everyone has start date to end date but I actually need end date to give me start date. Hope this makes sense and hoping you can help. Thank you.