Excel 2007 formula kicking my BUTT

jronald · **Posted:** Tue Jul 26, 2011 7:30 pm

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

craigmontHunter · **Posted:** Tue Jul 26, 2011 7:38 pm

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

jronald · **Posted:** Tue Jul 26, 2011 7:42 pm

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

craigmontHunter · **Posted:** Tue Jul 26, 2011 7:52 pm

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.

jronald · **Posted:** Tue Jul 26, 2011 7:57 pm

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

rkawakami · **Posted:** Tue Jul 26, 2011 9:17 pm

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

RealBlackStuff · **Posted:** Wed Jul 27, 2011 8:13 am

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?

ozzymud · **Posted:** Wed Jul 27, 2011 9:40 am

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

jronald · **Posted:** Sat Jul 30, 2011 12:52 pm

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

Excel 2007 formula kicking my BUTT

Who is online