| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates including the beginning date.
I am trying to set up a formula to count days from start date to end date
including the start day. I have a total of 30 date sets that I need to track and total. I have used =SUM(B3-A3)+1 and it accomplishes the task, but it also adds 1 for every set regardless of the presence of dates in the cells. I need it to only add what has been entered. Any help is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates including the beginning date.
Try this:
=(COUNT(A3:B3)=2)*(B3-A3+1) -- Biff Microsoft Excel MVP "chapy354" wrote in message ... I am trying to set up a formula to count days from start date to end date including the start day. I have a total of 30 date sets that I need to track and total. I have used =SUM(B3-A3)+1 and it accomplishes the task, but it also adds 1 for every set regardless of the presence of dates in the cells. I need it to only add what has been entered. Any help is greatly appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates including the beginning date.
You don't need the SUM function to subtract two cell values SUM(B3-A3) is
the same as B3-A3. As for you +1 problem, try this... =IF(AND(A3<"",B3<""),B3-A3,"") Rick "chapy354" wrote in message ... I am trying to set up a formula to count days from start date to end date including the start day. I have a total of 30 date sets that I need to track and total. I have used =SUM(B3-A3)+1 and it accomplishes the task, but it also adds 1 for every set regardless of the presence of dates in the cells. I need it to only add what has been entered. Any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting multiple values (including blanks) in one column | Excel Discussion (Misc queries) | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
| How do I create consecutive dates between a beginning and ending . | Excel Discussion (Misc queries) | |||
| Rouding Dates to beginning of a week | Excel Discussion (Misc queries) | |||
| Counting numbers in a column without including others | Excel Worksheet Functions | |||
Linear Mode
