 |
|---|
 |
 |
 |
| | |
|
|
| |||||||
 |
| | Thread Tools | Display Modes |
08-12-2008, 02:35 PM
| #1 (permalink) |
| Member  Join Date: Aug 2007 Location: Birmingham, AL
Posts: 1,515
| Number of Days Sober (Excel)
Here is a cool way to calculate the number of days you have sober. Using Excel and the formula, NETWORKDAYS. Example: =NETWORKDAYS(A2,A3) Returns the number of days betwen the two dates. A B C 1 Sobriety Date Todays Date Numbers of Days Sober 2 4/28/2003 8/12/2008 1382 Days Ron
__________________ "Life is rather like a tin of sardines - we're all of us looking for the key" Alan Bennett Excerpts; First Edition of the Big Book of Alcoholic Anonymous |
|      |
|
08-12-2008, 02:58 PM
| #2 (permalink) |
| Thumper  Join Date: Nov 2007 Location: Los Angeles Ca
Posts: 1,307
|
I have always been more of a : --------------------------------- declare @sober as datetime set @sober = sobriety_date select datediff(day,@sober,getdate()) where sobriety_date is not null ----------------------------------- kind of guy myself 
__________________ Although my eyes were open, they might have just as well've been closed.... |
|
| |
|
08-12-2008, 05:17 PM
| #6 (permalink) |
| Member  Join Date: Jun 2006 Location: Mobile, AL
Posts: 1,078
|
Type your sobriety date in cell A1. Enter a formula '=now()' in cell A2. Enter a formula in cell A3: '=A2-A1' KISS
__________________ If the only tool in your toolbox is a hammer, then all your problems look like nails....  |
|
| |
|
08-13-2008, 04:17 AM
| #8 (permalink) |
| Follow Directions!  Join Date: Nov 2006 Location: Fredericksburg, Va.
Posts: 7,343
|
Well I am patiently waiting for someone to pop up with a FORTRAN program!!!!
__________________ All BB quotes are from the First Edition of the BB Follow directions! Sobriety date 18 Sept. 2006 Sober today thanks to AA |
|
| |
|
08-13-2008, 06:14 AM
| #9 (permalink) |
| Member Join Date: Aug 2007 Location: Birmingham, AL
Posts: 1,515
|
LOL< truly! Rob, you are never a jackass to me! I had too much time on my hands yesterday and see what happens!
__________________ "Life is rather like a tin of sardines - we're all of us looking for the key" Alan Bennett Excerpts; First Edition of the Big Book of Alcoholic Anonymous |
|
| |
|
08-13-2008, 08:48 AM
| #10 (permalink) |
| Om, Aum, Ohm...  Join Date: Jul 2005 Location: Punxsutawney/Pittsburgh
Posts: 2,633
|
Wow. We have some bona fide geeks on board! Awesome! (My first language was B.A.S.I.C., Taz - I was 12.) Peace & Love, Sugah
__________________  There's a train leaving nightly called when all is said and done Keep me in your heart for awhile ~WZ ANS 01/29/86 - 08/04/08 |
|
| |
|
08-13-2008, 09:47 AM
| #12 (permalink) |
| Follow Directions! Join Date: Nov 2006 Location: Fredericksburg, Va.
Posts: 7,343
|
BASIC, Fortran, COBAL, C, C+, C++, VOS...... learned BASIC and even machine language in 78. I have actually worked with computors that we programmed with PC boards.AND gates, NAND Gates, OR & NOR gates, each board was an individual gate. I have used punch cards, and 9 track tapes, I can remember thinking I was hot stuff because I had 64K of RAM!!!! I can recall when we got our first 1 GIG drive developers saying "Man there is no way we could use all that disk space!!!!
__________________ All BB quotes are from the First Edition of the BB Follow directions! Sobriety date 18 Sept. 2006 Sober today thanks to AA |
|
| |
|
08-13-2008, 09:56 AM
| #14 (permalink) |
| Member Join Date: Aug 2007 Location: Birmingham, AL
Posts: 1,515
|
I can remember memory costing more than cocaine......... Yikesssssss!
__________________ "Life is rather like a tin of sardines - we're all of us looking for the key" Alan Bennett Excerpts; First Edition of the Big Book of Alcoholic Anonymous |
|
| |
|
08-13-2008, 10:46 AM
| #15 (permalink) |
| Not the center of the Universe  Join Date: Jun 2004 Location: Orchard Lake, Michigan
Posts: 771
|
Apparently, a knowledge of bits and bytes is not sufficient defense against alcoholism either... Programing to pay the bills since 1986 (for a FORTRAN company no less).
__________________ Yes, I am an alcoholic. But that's not all that I am... |
|
| |
|
08-13-2008, 05:45 PM
| #17 (permalink) |
| Forum Leader  Join Date: Jun 2002 Location: Dallas, Ga. USA
Posts: 16,035
| By the time I figure out what y'all are talking about and actually do it.... It will be tomorrow and my day count moved. Pass
__________________  Each Day Sober Is A Victory!! Joy In AA Recovery!  |
|
| |
|
08-13-2008, 05:58 PM
| #18 (permalink) |
| Member  Join Date: Nov 2007
Posts: 7,537
|
I remember my dad buying his first "electric slide rule"....it could add, subtract, multiply, divide and figure out square roots.....Cost him 1K and it was big! He did computers back before computers were real I think. And I remember how proud he was of his first Wang computer (5k back in the 70s and i don't think it did much more than the electric slide rule except random number generation..that was a big concept back then). My mom always resented the time and the money...as a result she won't even use self checkout and has no computer at all. |
|
| |
|
| Currently Active Users Viewing this Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 148 Days Sober | bookie121157 | Newcomers to Recovery | 13 | 01-25-2008 01:39 PM |
| Number one thing about being sober? | *amelia* | Women In Recovery | 27 | 06-27-2007 11:39 AM |
| Opportunity to Excel...... | recoveringangel | Narcotics Addiction-12 Step Support | 1 | 06-02-2006 09:36 PM |
| 90 days sober and goin' sober CRAAZY!!! | ARIES | What is Recovery? | 5 | 02-17-2005 09:55 PM |
| 17 days sober | allaroundtown | Newcomers to Recovery | 8 | 12-03-2004 11:04 AM |
| |
© 2007 SoberRecovery, LLC. |
The SoberRecovery Forums are operated under a grant from The Mulligan Group
Linear Mode
