Date (hours and still counting)

B

_Bigred

I need to have a formula that will do the following:

Count from July 1st, 2005 til present (not past June 24th, 2006).

then provide the number of hours eclipsed based on a sun thru sat 40 hrs per
week. I don't really have to worry about holidays, but might be a helpful
piece of info for future calc's.

TIA,
_Bigred
 
D

daddylonglegs

The formula

=NETWORKDAYS(DATE(2005,7,1),MIN(TODAY(),DATE(2006,6,24)))*8

will give you the working hours elapsed (including today). If you wan
to add holidays you can add a range of dates as the 3rd argument o
NETWORKDAYS

note: NETWORKDAYS is part of the Analysis ToolPak add-i
 
Top