Date manipulation
 

Your problem might be solved but if at some stage you want to take it a bit
further check this usefull site:-

http://www.cpearson.com/excel/holidays.htm

Vsn


"Rick A" wrote in message
...
I need a boost.

I need to calculate a start date based on an end date and hours and wonder
how to do it.

For example, If the end date is Friday and the number of hours is 8 the
start date needs to be Friday too. If the end date is Friday and the
number of hours is between 8 and 16 the start date needs to be Thursday.
And so on. I need to take into account weekends but I'm going to ignore
holidays for now.

I'm having a hard time figuring out how to subtract hours from a date. I
need to consider each date as being a 8 hour day too.

Your help is appreciated.

--
Rick