Summing PICC days totals

[grierfield]

An excel question ----I have a situation where a PICC is inserted in a patient – I want to count the number of days that the PICC is inserted until it is removed………for example – if the PICC was inserted on 3/10/2013 and removed on 3/23/2013 – I calculate the number of insertion days with this formula

Σ(3/23/2013 – 3/10/2013)+1

If the PICC is not removed but I want an automatic daily running count of the PICC days – how would I setup a cell formula to get the daily total PICC days?

 

[ClulessChris]

Maybe
Σ(Date() – 3/10/2013)+1

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[grierfield]

Unfortunately i keep getting an error message with that formula - it did not work

 

[ClulessChris]

Have you looked at dateDiff?

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[ClulessChris]

Or to stick with the formula you first posted
Σ(Today() – 3/10/2013)+1

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[grierfield]

Still a no-go ........i am using the Excel summation formula which comes out like this
=Σ(Date() – 3/10/2013)+1 or =Σ(Today() – 3/10/2013)+1.......still does not work

 

[SkipVought]

How about posting the ACTUAL FORMULA with appropriate explaination regarding references if appropriate.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[grierfield]

thanks guys - from all the input i was able to garner enough to set me on the right path......thanks again

 

[SkipVought]

Please post your solution, as there are other members who might benefit from your conclusion.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[grierfield]

=SUM(TODAY()) – date +1
On the excel spread setup your set your columns with “startDate” cell then from the excel DATA menu – select “Date & Time” then from the dropdown list select “Today”……. Then in the cell that you want the difference of the two dates you place the formula =SUM(TODAY()) – date +1 (note – you only add the 1 if you want to include the start date) you can then copy the formula to the entire results column……
My first posting solution – hope its of value

 

[zelgar]

Your code can be simplified by getting rid of the SUM() portion of your formula and end up with the foloowign code:
=TODAY() - date + 1