Adding working days to a date is not full-proof, as you can consider only Saturday and sundays as non-working days and not public holidays. Still try using the weekday() function in an IF(). Based on the value returned by weekday() (sat or sun) add appropriate number of days to the date. If you have maintained a list of public holidays for the year, you can even implement checking for public holidays. Regards
Ajit On Tue, Oct 7, 2008 at 12:45 AM, sanj <[EMAIL PROTECTED]> wrote: > > I have a date in a1; in a2 I want to add 2 working days. > As per example: 3rd Oct, 2008 + 2 working days = 7th October, 2008 > > It will be a great help from u.....!!! > > Thanks > > > > -- Thank You, Ajit Navre --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
