excel formula counting date to date in 4 columns
 

I am trying to find a formula for an excel spreadsheet that calculates the
number of days between two dates and show in the 3rd cell, the number of days
that have elapsed, i.e., date on site in column one, date off site in column
two and in column three, the amount of days to show automatically. The fourth
column would be for the counting to stop.

If you want to include weekend days, just use =B1-A1.

If you want to exclude weekend days, use NETWORKDAYS, part of the analysis
toolpak.

--
HTH

Bob Phillips

"stuie d" <stuie wrote in message
...
I am trying to find a formula for an excel spreadsheet that calculates the
number of days between two dates and show in the 3rd cell, the number of
days
that have elapsed, i.e., date on site in column one, date off site in
column
two and in column three, the amount of days to show automatically. The
fourth
column would be for the counting to stop.