Excel 2007 formula kicking my BUTT

[jronald]

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]

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]

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]

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: Select all

=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: Select all

=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: Select all

=now()+x

, where x is the number of days.

[jronald]

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]

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]

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]

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]

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