thinkpads.com Support Community Forum Index Bill Morrow's thinkpads.com Open Forum - The Original Thinkpad Support Forum
Follow ThinkpadsForum on Twitter
eCoupons
Save with Lenovo ThinkPad eCoupons
Exclusive 4% CASH BACK from eCoupons.com
Support this forum, shop at newmodeus.com
 
It is currently Sat May 18, 2013 2:12 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Excel 2007 formula kicking my BUTT
PostPosted: Tue Jul 26, 2011 7:30 pm 
Offline
Contributing Member
Contributing Member

Joined: Sun Apr 13, 2008 7:11 pm
Posts: 1304
Location: RTP, North Carolina
Simple formula:
Cell "N" auto loads today's date. 7/26/2011
Cell "C" is the date the item arrives
Cell "M" is the difference in the date between "N" - "C" in days

So if the arrival is 7/20/2011 the right answer is 6 (just the number 6 nothing else).
I have tried more than 40 formulas that dont work. Ill email the file to anyone willing to take a stab at it.

Anyone game?

Ron

_________________
I see in my son's eyes, each day, the wonders I have squandered fortunes to possess and have sought my entire lifetime to attain.

X30 a few
X31 a few more
T30 (down to one, the rest donated)
Z60t (my NEW primary)
Z61m (wife's new daily driver)


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Tue Jul 26, 2011 7:38 pm 
Offline
Senior Member
Senior Member

Joined: Wed Feb 18, 2009 10:25 pm
Posts: 741
Location: Ottawa, Ontario, Canada
Does anything on this site help?

http://www.meadinkent.co.uk/xl_birthday.htm

if not, I'll take a stab at it.

EDIT:

Another site that seems to explain it better:
http://www.cpearson.com/excel/datedif.aspx

_________________
Elitebook 8440p, i5 520, 8gb, Samsung 840 SSD
Old/Not Working/Dead Laptops:
T61 7661CC2, 4gb, Windows 7 x64, 240gb intel SSD, 500gb Ultrabay drive
Toshiba Portege 7020ct
Thinkpad T41 23737FU
Dell Latitude LS


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Tue Jul 26, 2011 7:42 pm 
Offline
Contributing Member
Contributing Member

Joined: Sun Apr 13, 2008 7:11 pm
Posts: 1304
Location: RTP, North Carolina
I tried to use the dateif could not get it to work...I kind of wonder if its the auto input of today"s date, but I dont know enough about Excel.

Ron

_________________
I see in my son's eyes, each day, the wonders I have squandered fortunes to possess and have sought my entire lifetime to attain.

X30 a few
X31 a few more
T30 (down to one, the rest donated)
Z60t (my NEW primary)
Z61m (wife's new daily driver)


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Tue Jul 26, 2011 7:52 pm 
Offline
Senior Member
Senior Member

Joined: Wed Feb 18, 2009 10:25 pm
Posts: 741
Location: Ottawa, Ontario, Canada
I just tried it in excel 2010 - in order to get the diffrence in days between two cells (in this case A1 and A2), the formula is:
Code:
=DATEDIF(A1,A2,"d")
and the date is entered in the form DD/MM/YYYY. In order to enter today's date, format the cell as a date value, and use the command
Code:
=now()
- this will automatically insert todays date in the correct format.

EDIT: in order to add a specific number of days to the equation (i.e. to figure out the date six days from now) just use the code
Code:
=now()+x
, where x is the number of days.

_________________
Elitebook 8440p, i5 520, 8gb, Samsung 840 SSD
Old/Not Working/Dead Laptops:
T61 7661CC2, 4gb, Windows 7 x64, 240gb intel SSD, 500gb Ultrabay drive
Toshiba Portege 7020ct
Thinkpad T41 23737FU
Dell Latitude LS


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Tue Jul 26, 2011 7:57 pm 
Offline
Contributing Member
Contributing Member

Joined: Sun Apr 13, 2008 7:11 pm
Posts: 1304
Location: RTP, North Carolina
Did not work comes up #NAME?

I used the same formula as your suggestion except I used =TODAY()

Ron

EDIT
Basically I need the number of days the item has sat, between when it was inventoried IN until today. The longer it sits, the more days get automatically added.

Ron

_________________
I see in my son's eyes, each day, the wonders I have squandered fortunes to possess and have sought my entire lifetime to attain.

X30 a few
X31 a few more
T30 (down to one, the rest donated)
Z60t (my NEW primary)
Z61m (wife's new daily driver)


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Tue Jul 26, 2011 9:17 pm 
Offline
Admin
Admin

Joined: Sun Jun 04, 2006 1:26 am
Posts: 8454
Location: San Jose, CA 95120 USA
The problem appears to be that you can't have "C" as the cell name. At least I had a problem with Excel 2003. Call it "Q" and then see if it works. It did for me :) .

File: http://www.kawakami-ca.com/excel/jronald.xls

_________________
Ray Kawakami
[DONOR] X22;X24;X31;X41;X41T;X60;X60s;X61s;X300;Z60m;Z61t;Z61p;560Z;600E;600X;T21;T22;T23;T41;R50;A21p;A22p;A31 and A31p
NOTE: All links to PC-Doctor software hosted by me are now dead. Files were removed 8/28/12 by manufacturer's demand.


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Wed Jul 27, 2011 8:13 am 
Offline
RBS10000
RBS10000

Joined: Mon Sep 18, 2006 5:17 am
Posts: 11773
Location: Mt. Cobb, PA USA
Alternatively, and to avoid confusion:

.......Today.... Delivered Days
07/26/2012 07/20/2012 6

Today is a date in cell A10
Delivered is a date in cell B10
Days is a number in cell C10.
The formula used in cell C10 is: =(A10-B10)

Why do it complicated if you can do it easy?

_________________
Lovely day for a Guinness! (The Real Black Stuff)

Check out The Board Room for:
- SATA-mods: native SATA for T43/R52 with ATI GPU
- other Services


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Wed Jul 27, 2011 9:40 am 
Offline
Senior Member
Senior Member

Joined: Sun Apr 03, 2011 3:38 pm
Posts: 593
Location: Klamath Falls, OR
Should work, I just put in:

A1: 07/21/2011 showed exactly as manually entered
B1: =TODAY() this gave 07/26/2011
C1: =(B1-A1)

A3 changed to just "6", seems simple enough :)

_________________
(2)701C,(1)760EL,(6)760XL,(1)760XD
(4)CD Drives (5)int floppies (3)ext floppy (4)2.1GB
(10)CF/IDE w/2 or 4GB 133x CF (1)760XL restore CD
(1)Belkin USB 2.0 32bit Cardbus (2)WPC54G(S) Wifi Cardbus
(1)Belkin F5D5020 NIC (1)Giga-Byte GN-WLM01 Wifi
(1)Backpack CD (1) Xircom REM56G-10 + misc


Top
 Profile  
 
 Post subject: Re: Excel 2007 formula kicking my BUTT
PostPosted: Sat Jul 30, 2011 12:52 pm 
Offline
Contributing Member
Contributing Member

Joined: Sun Apr 13, 2008 7:11 pm
Posts: 1304
Location: RTP, North Carolina
I never got it to work in 2004 or 2007, however with a little help from my friends (TP friends) It worked in 2010, then down graded to 2007 and still works. Go figure.

Ron

_________________
I see in my son's eyes, each day, the wonders I have squandered fortunes to possess and have sought my entire lifetime to attain.

X30 a few
X31 a few more
T30 (down to one, the rest donated)
Z60t (my NEW primary)
Z61m (wife's new daily driver)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group