Hi The other solution offered, has the -1 outside of the parentheses. This is incorrect. The formula should be =WORKDAY(B3,F3-1)
You need the Analysis Toolpak loaded, Tolls>Addins>Analysis Toolpak. Note, you can also Exclude holidays as well as Weekends with the Workday function. If you have a list of Holiday dates in cells A1:A12, then use =WORKDAY(B3,F3-1,$A$1:$A$12) Regards Roger Govier Microsoft Excel MVP 2009/4/30 Harmeet Singh <harmeet.hew...@gmail.com> > > > On Thu, Apr 30, 2009 at 7:33 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 >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > > > -- Roger Govier rogergov...@gmail.com --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
