Date Formulae

P

pauluk

Hi People,

Am looking for a formulae that will do the following:

First: calculate the number of days between two dates.

Second: Calculate the number of working days between to dates, were th
working days are monday to friday.

Thanks
Paul

p.s the new look is goo
 
G

Guest

hi,
=NETWORKDAYS(C8,D8,E8:E11)
where c8 is start day and d8 is end date and e8:e11 is a
range of holidays.
the other formula...
=C8-D8
where c8 is start date and D8 is end date.
format formula cell as number.
 
A

Andy Brown

First: calculate the number of days between two dates.

=B1-A1-1

Format the result cell as Number, 0 DPs, or General.
Second: Calculate the number of working days between to dates, were the
working days are monday to friday.
Click to expand...

Use the NETWORKDAYS function. You'll need Analysis ToolPak installed
(Tools -- Add-Ins).

Rgds,
Andy
 
Top