excel formula counting date to date in 4 columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Average dates help 0
Excel Formula - Count Dates from another Sheet 8
Count dates until complete or Cancel 5
FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES 4
formulas to count dates 2
date function 10
count dates 4
counting dates <= 7 days ago based on criteria in a diff column 1

Back
Top