Hi Andril, WORKDAY function is the right way to solve this (I too believe). But is this the best solution, keeping in mind Praveen's primary condition in the first box?
Primary Condition: The end date + duration - 1 (I believe, he is assuming that some work is done on the date the work is received, making it inclusive) In this scenario, the formula =WORKDAY(B3,F3) works well (to an extent though it doesn't take Praveen's primary condition of including the day work is received) and not =WORKDAY(B3,F3)-1 (a) in the former case, excel assumes that on THE START DAY no work is not done at all, that is, it assumes that the work is not done on 27th April 2009. The system calculates the 6 days from Tuesday and not Monday, hence the result is next Tuesday and not Monday, which is erroneous. (b) in the latter case, -1 works well when the duration of the work is 6 days. Make it 5 days and the work ends on a Sunday which is weekend, which is not correct. I am quite novice as compared to many guys in this group. Would appreciate your thoughts. Regards, Sastry 2009/4/30 Aindril De <aind...@gmail.com> > Hi Praveen, > > Have see your worksheet. Please use: > =WORKDAY(B3,F3)-1 in cell D3 to get the desired result. > This same formula can be copied down in column D for next set of entries. > > Notes: > 1) In older versions of Excel, it is not available unless you have the > Analysis Tool Pak loaded. > On the Tools menu, click Add-Ins. > In the Add-Ins available list, select the Analysis ToolPak box, and then > click OK. > 2) To view the number as a date, select the cell and click Cells on the > Format menu. Click the Number tab, and then click Date in the Category box. > > Suggestion: > In case you are trying to manage a project, you can try using MS Project > instead of trying to do it yourself. > > Hope it helps. > > Regards, > Andy > > On Thu, Apr 30, 2009 at 9:03 PM, Praveen Khunte <praveen.khu...@gmail.com > > wrote: > >> Hi All Excel Lovers >> >> I have attached the excel sheet with the problem description. >> Hope to get solution. >> >> Praveen Khunte >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
