Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2020, 10:35 AM
jthomas666 jthomas666 is offline Formula for calculating dates based on Business Days Windows 10 Formula for calculating dates based on Business Days Office 2016
Competent Performer
Formula for calculating dates based on Business Days
 
Join Date: Jun 2016
Location: Birmingham & Warner Robins
Posts: 125
jthomas666 will become famous soon enough
Default Formula for calculating dates based on Business Days


I've been put in charge of managing delivery of of number of regular reports. The dues dates for many of these reports are basically a specific number of business days before/after a trigger date.

For example, a certain set of reports is due 15 business days after a version release.

I need a formula that lets me set the rule for a report so that in Excel, I can enter the trigger date and Excel will calculate the due date.

Is this doable?

thanks
Reply With Quote
  #2  
Old 02-28-2020, 01:35 PM
NBVC's Avatar
NBVC NBVC is offline Formula for calculating dates based on Business Days Windows 10 Formula for calculating dates based on Business Days Office 2016
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enough
Default

Have a look at the Workday() function:


e.g. =WORKDAY(A1,14) will add 14 business days to date in A1.


You even can include specified holiday dates to avoid in the calculation.
Reply With Quote
  #3  
Old 03-02-2020, 09:05 AM
jthomas666 jthomas666 is offline Formula for calculating dates based on Business Days Windows 10 Formula for calculating dates based on Business Days Office 2016
Competent Performer
Formula for calculating dates based on Business Days
 
Join Date: Jun 2016
Location: Birmingham & Warner Robins
Posts: 125
jthomas666 will become famous soon enough
Default

Just what I needed! Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for calculating dates based on Business Days Calculating Quarterly Dates by Months not Days Artboy34 Excel 3 01-28-2016 09:47 AM
Calculating Average Time across days lizakay Excel 3 11-25-2015 05:16 PM
Conditional formatting using a formula that will result in different colors based on dates 19z Excel 3 05-28-2015 11:39 AM
Excel Formula Showing Revenue Recognition Based on Days and Months stratcat Excel 4 03-16-2014 10:09 AM
Calculating 6.5hr work days altja Project 3 02-10-2014 03:11 PM


All times are GMT -7. The time now is 09:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft