Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |