how do i know date after no. of working days

[sudheer]

I want to know what is the date after no. of working days.
Suppose if we consider today's date i have to get date after 12 wrkng days .
Today's date:3-oct-08
Date aftr 12 wrkng days :21-oct-08(Result)

I need formula to execute that and how to implement it in shared workbooks ?

 

[Pete_UK]

Use the WORKDAY function:

=WORKDAY(start_date,days)

or you can add a third parameter relating to holidays.

You need to install the Analysis ToolPak for this to work if you are
using Excel 2003 or earlier - see Excel Help for further details.

Hope this helps.

Pete

 

[Rick Rothstein]

Give the following function a try...

Function AddWorkDays(StartDate As Date, WorkDays As Long) As Date
If WorkDays < 0 Then Exit Function
AddWorkDays = DateAdd("d", 7 * (WorkDays \ 5) + (WorkDays Mod 5) - _
2 * ((WorkDays Mod 5) > Abs(5 + - _
Weekday(StartDate, vbMonday))) + _
Weekday(StartDate, vbSaturday) * _
(Weekday(StartDate, vbSaturday) < 3), StartDate)
End Function

As written, this function will only *add* workdays to the StartDate. If the
WorkDays value is less than 0, then "day zero" (12/30/1899) is returned and
can be used for error checking purposes.

 

[Rick Rothstein]

It just occurred to me that my solution (a VB coded solution) is probably
not what you were looking for. I had just posted some answers over in the
programming newsgroup and forgot that I was not still in that newsgroup when
I posted my answer to you. I think Pete's answer is the one you are looking
for.

 

[Pete_UK]

I thought that was a bit OTT, Rick !! <bg>

Pete

It just occurred to me that my solution (a VB coded solution) is probably
not what you were looking for. I had just posted some answers over in the
programming newsgroup and forgot that I was not still in that newsgroup when
I posted my answer to you. I think Pete's answer is the one you are looking
for.

--
Rick (MVP - Excel)








- Show quoted text -

 

[Rick Rothstein]

Well, maybe a little. However, if the OP doesn't want to use the Analysis
ToolPak for some reason, or if he is afraid that users he distributes the
worksheet to might not have it turned on, he can always place my function in
a Module and then use it as a User Defined Function (UDF) directly on the
worksheet.

--
Rick (MVP - Excel)


I thought that was a bit OTT, Rick !! <bg>

Pete

 

[Sean Timmons]

and I've learned yet another piece of code. I could be a certified VB
programmer in about 3 months just by reading the posts!