If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have two dates (start and end). I want to know how many working days are there between these two dates (both inclusive). If there is a ready function in Excel, I would like to know that.
Also I have list of holidays that I would want to process while computing the number of working days and not just saturday and sunday. How I can do this. Thanks.
See the Workdays and NetWoirkdays functions in Excel Help.
As Help explains, the functions are part of the Analysis ToolPak.
---
Regards,
Norman
"nougain" <nougain.2432kz_1141371902.3213@excelforum-nospam.com> wrote in
message news:nougain.2432kz_1141371902.3213@excelforum-nospam.com...
>
> I have two dates (start and end). I want to know how many working days
> are there between these two dates (both inclusive). If there is a ready
> function in Excel, I would like to know that.
>
> Also I have list of holidays that I would want to process while
> computing the number of working days and not just saturday and sunday.
> How I can do this. Thanks.
>
>
> --
> nougain
> ------------------------------------------------------------------------
> nougain's Profile:
> http://www.excelforum.com/member.php...o&userid=32031
> View this thread: http://www.excelforum.com/showthread...hreadid=518584
>
"nougain" <nougain.2432kz_1141371902.3213@excelforum-nospam.com> wrote in
message news:nougain.2432kz_1141371902.3213@excelforum-nospam.com...
>
> I have two dates (start and end). I want to know how many working days
> are there between these two dates (both inclusive). If there is a ready
> function in Excel, I would like to know that.
>
> Also I have list of holidays that I would want to process while
> computing the number of working days and not just saturday and sunday.
> How I can do this. Thanks.
>
>
> --
> nougain
> ------------------------------------------------------------------------
> nougain's Profile: http://www.excelforum.com/member.php...o&userid=32031
> View this thread: http://www.excelforum.com/showthread...hreadid=518584
>
Linear Mode
