HELP! with microsoft Excel please!?

Question

i have a formula set up, which is: =DATEDIF(D9,NOW(),"D")
this tells me in the next column how many days that date was from TODAYS date, i.e. if ic one column i put in 9/20/2006 it would tell me 2days. How can i change this to work out how many days have passed from a specific date to ANOTHER date? i want all figures to work out days from, til September 5th 2006.

Answer 1

Put the date you want to calculate from in a cell, say D10 for example.

Now change your formula - remove the bit that says NOW() and replace it with the cell reference you just put the new date in, like this -

=DATEDIF(D9,D10,"D")

Hope this helps.

Answer 2

I would have done it simply by using subtract operator between two dates without using any function. Please follow the instructions below:


in cell D9 enter some date (From date) e.g., 9/20/2006

In Cell D10 enter another date (To date) e.g., 9/23/2006

In Cell D11 enter the formula =+D10-D9

Please note that the format of cell D11 should be Number with 0 decimal places.

Hope this will solve your problem in simplified way.

Alternatively if you want to use your user-defined function DATEDIF, then just replace NOW() with a cell number e.g., D10 in this case. And enter some date in D10 as mentioned earlier.

Answer 3

I have a slightly different way to do it.
Since dates are just numbers in Excel, specifically the number of days from the beginning of the 20th century (1 = 1/1/1900), you can just add/subtract them (in other words, just use a simple math formula like, =B2-A2). Just make sure the cell with the result is formatted as a number, not a date.

If you still want to use NOW as a date, you can try something like =(NOW())-A2.

Answer 4

Do a search in Excel help "Calculate the difference between two dates" and you will see an example of how this is done.

You can use the formula "=A1-A2" to work out the number of days between two dates A1 and A2. Hope this helps.

Answer 5

To Work with Excel Dates and Times, you first need to understand Excels way of using them. This should give you all the information you need, and its free.
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Answer 6

ask microsoft