Date Formulae

[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

 

[Frank Kabel]

Hi
1. =A2-A2 and format this cell as number
2. =NETWORKDAYS(A1,A2)

 

[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.

 

[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.

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

Rgds,
Andy