Count the number of days.

[wkirkcrawford]

Greetings,

I keep a diabetic log that is usually 6 months or so. One insulin pen last 28 days and I have a column that I note starting a new pen. I usually have don’t use it all by the 28^th day. Therefore, I need to replace that pen.

Today, I’m taking that pen twice a day. Usually, I run out before the 28^th day now. But not always.

So, I need a way to flag me when I need to replace it. Therefore, I assume it would be something using Conditional Formatting.

W. Kirk Crawford
Tularosa, New Mexico

 

[TotallyConfused]

Hello WKirkCrawford

I'm not sure if this is what you are needing or not, but maybe it will get you started in the right direction. I assume your data starts in row A2. First, I formatted the 'A' column as DATE. You can pick which option you prefer. Then in cell 'A2', I entered today's date as 2019/2/4, the date you started using a new pen. The second thing I'm assuming is that you want to order a new pen a few days before your old one is finished. If the old one lasts 28 days, I randomly picked 25 as when you'd want to order a new one, which would give you a three day advance warning. You can adjust that number to suit your needs. Using my examples, cell 'B2' would show March 1, 2019 as 25 days after you started using that pen.

In cell 'B2' I entered the following formula and copied/pasted it down the column.

[COLOR=black][FONT=Calibri]=IF(A2="","",A2+25)[/FONT][/COLOR]

I hope this helps.

TotallyConfused

 

[wkirkcrawford]

Totally,

It's a start, but I'm trying to insert a snapshot or screen dump of what I'm talking about. Can't seem to get it to work.

The column when I get a new pen, I put an asterisk on that date.

W. Kirk Crawford
Tularosa, New Mexico

 

[wkirkcrawford]

Re: Count the number of days. Link added

I've add most of my log.
Where's the red asterisk, it the day I started using a new PEN.
I want to know when it's time to start using a new pen after 28 days.

W. Kirk Crawford

All Readings Breakfast Lunch Dinner Before Snack Sugar Drops High 255 Avg. time between the last shot. High 172 Avg. time between the last shot. High 193 New Pen Avg. time between the last shot. High 255 Humlog High 199 High 91 Low 71 Low 108 Low 85 Low 110 Low 94 Low 71 Average 151 Average 145 Average 127 Average 190 Average 148 Average 81 Median 150 Median 149 Median 122 Median 183 Median 151 Median 81 Date: Morning 13:36 Reading Units Afternoon 5:33 Reading Units Dinner 4:46 Reading Units Units Time Reading Time Reading 1/16/2019 12:10 PM 98 7 4:00 PM 3:49 182 18 9 7:56 PM 171 1/17/2019 5:42 AM 13:42 129 24 11:01 AM 5:19 104 7 4:02 PM 5:01 209 18 9 7:59 PM 147 1/18/2019 5:14 AM 13:11 131 24 11:02 AM 5:47 132 8 4:01 PM 4:59 222 18 10 7:59 PM 132 1/19/2019 6:14 AM 14:12 108 24 11:06 AM 4:51 188 9 4:20 PM 5:14 216 18 9 8:04 PM 167 1/20/2019 6:15 AM 13:54 146 24 11:56 AM 5:40 116 9 4:08 PM 4:12 191 18 9 8:02 PM 119 1/21/2019 6:05 AM 13:57 151 24 11:03 AM 4:57 97 7 4:02 PM 4:59 177 18 9 8:01 PM 147 1/22/2019 5:36 AM 13:33 149 24 11:09 AM 5:33 111 7 4:06 PM 4:56 159 18 8 8:05 PM 127 1/23/2019 6:00 AM 13:54 155 24 11:05 AM 5:05 122 9 4:01 PM 4:56 239 18 11 8:00 PM 166 1/24/2019 5:54 AM 13:52 157 24 11:01 AM 5:06 137 9 4:11 PM 5:10 110 18 7 8:02 PM 103 1/25/2019 6:29 AM 14:18 130 24 11:09 AM 4:39 124 8 4:14 PM 5:04 170 18 8 8:01 PM 157 1/26/2019 5:54 AM 13:40 128 24 11:07 AM 5:13 130 8 4:12 PM 5:04 226 18 10 8:01 PM 110 1/27/2019 5:43 AM 13:31 128 24 11:59 AM 6:16 100 9 4:05 PM 4:05 255 18 12 8:02 PM 123 12:33 PM 71 1/28/2019 5:49 AM 13:44 151 24 11:06 AM 5:16 147 8 4:02 PM 4:55 168 18 8 8:02 PM 168 1/29/2019 5:22 AM 13:20 150 24 11:01 AM 5:38 118 7 4:01 PM 5:00 192 18 9 7:58 PM 94 7:21 AM 91 1/30/2019 5:51 AM 13:50 161 24 11:06 AM 5:14 132 8 4:13 PM 5:07 163 18 8 8:00 PM 192 1/31/2019 5:35 AM 13:21 144 24 11:09 AM 5:34 129 8 4:03 PM 4:54 153 18 8 8:04 PM 175 2/1/2019 5:39 AM 13:36 172 24 11:03 AM 5:23 85 7 4:16 PM 5:13 226 18 10 7:57 PM 131 2/2/2019 5:02 AM 12:45 157 24 1:31 PM 8:28 120 8 5:33 PM 4:02 243 18 10 7:58 PM 146 2/3/2019 5:53 AM 12:20 171 24 12:11 PM 6:17 101 7 * 4:06 PM 3:54 190 18 9 8:07 PM 199 2/4/2019 5:16 AM 13:10 149 24 11:01 AM 5:45 193 9 4:02 PM 5:01 162 18 8 8:02 PM 168 2/5/2019 5:35 AM 13:32 146 24 11:07 AM 5:32 121 8 3:06 PM 3:58 181 18 9 10:19 PM 151 2/6/2019 6:13 AM 15:06 172 24 11:02 AM 4:49 138 8 4:02 PM 4:59 158 18 8 8:00 PM 164 2/7/2019 5:12 AM 13:10 119 24 11:04 AM 5:51 174 9 4:02 PM 4:58 183 18 9 8:01 PM 154 2/8/2019 5:17 AM 13:14 123 24 <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[sandy666]

Re: Count the number of days. Link added

complicated

 

[wkirkcrawford]

Re: Count the number of days. Link added

Sandy666,

What's so complicated about it?

W. Kirk Crawford
Tularosa, New Mexico

 

[jtakw]

Re: Count the number of days. Link added

Hi,

If I understand correctly...

You would need to replace the "Pen" when it's depleted or on the 28th day (maybe 29th day), whichever comes first, is that correct ?

It's kind of difficult to follow your Table as shown above, probably easy for you since you created it.

Which column shows, How many times the "Pen" has been used since last replaced, and the date it was last replaced?

Also, need to know, How many times can a "Pen" be used, and whether it expires on or after the 28th day.

 

[sandy666]

Re: Count the number of days. Link added

Sandy666,
What's so complicated about it?

Ops, I was not talking about the problem but about the table

 

[wkirkcrawford]

Re: Count the number of days. Link added

Sandy666,

Would you like the file?

W. Kirk Crawford
Tularosa, New Mexico

 

[sandy666]

Re: Count the number of days. Link added

Would you like the file?

No thanks, I've my own