Hello,
The workday function can return the end date based on start date and duration, excluding weekends. However, I want to calculate start date based on end date and duration also weekends.
For example
Start Date: ?
Finish Date: 27 Jul 2010
Duration: 3 days
The Start Date should be 24 July 2010
I would very much appreciate it if you would take a look at this problem, many thanks in advance for your help!
Regards,
Kaatje
Last edited by kaaver; 06-14-2010 at 09:17 AM.
The WORKDAY() function works in both directions.
A3 --- End Date
A4 --- Duraition
Formula in A2:
=WORKDAY(A3, -A4)
The answer is 22 July, 2010, though.
If you do not want to skip weekends:
=A3-A4
...formatted as Date.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Try
=WORKDAY(end_date,-days)
Simple answer, I should have known this! Thanks to you both!
Regards,
Kaatje
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks