Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
I'm using Excel 2000 and trying to use the datedif function. I've formated 2
columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
The first date must be earlier than the second date. Try
=DATEDIF(A1,B1,"m") See www.cpearson.com/excel/datedif.htm for more information. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JohnH" wrote in message ... I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
a1,b1
-- Don Guillett SalesAid Software "JohnH" wrote in message ... I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
From Chips' site http://www.cpearson.com/excel/datedif.htm
=DATEDIF(Date1,Date2,Interval) Date1 must be less than (earlier) or equal to Date2. Otherwise, =DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a date, =DATEDIF will return a #VALUE! error. By the way: You do not need to format cells before entering dates. Just type the data as, for example, 1/1/2002 and Excel recognizes a date. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "JohnH" wrote in message ... I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
Hi John, datedif calculates de difference of the two dates, but the formula
must be DATEDIF(INITIAL DATE,LAST DATE,TYPE OF DIF) Try to put Datedif(a1,ba,"m") hope this helps regards from Brazil Marcelo "JohnH" escreveu: I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
Hi
For case earlier/later dates aren't ordered column-wise =DATEDIF(MIN(A1,B1),MAX(A1,B1),"m") Arvi Laanemets "Chip Pearson" wrote in message ... The first date must be earlier than the second date. Try =DATEDIF(A1,B1,"m") See www.cpearson.com/excel/datedif.htm for more information. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JohnH" wrote in message ... I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
Thanks All. Reversing the formual was the solution.
Thanks Much! John "JohnH" wrote: I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
Try reversing the order of b1 and a1. In the test I tried, that's how I got
rid of the #num error. Kevin Vaughn "JohnH" wrote: I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
That's weird. I could have sworn when I looked at this question, there were
no replies. Then I replied and I see like 8 people have already answered. -- Kevin Vaughn "Kevin Vaughn" wrote: Try reversing the order of b1 and a1. In the test I tried, that's how I got rid of the #num error. Kevin Vaughn "JohnH" wrote: I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
BTW when I answered this there were NO other replies.
-- Don Guillett SalesAid Software "Kevin Vaughn" wrote in message ... That's weird. I could have sworn when I looked at this question, there were no replies. Then I replied and I see like 8 people have already answered. -- Kevin Vaughn "Kevin Vaughn" wrote: Try reversing the order of b1 and a1. In the test I tried, that's how I got rid of the #num error. Kevin Vaughn "JohnH" wrote: I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
Thanks for letting me know it's not just me. Don Guillett Wrote: BTW when I answered this there were NO other replies. -- Don Guillett SalesAid Software "Kevin Vaughn" wrote in message ... That's weird. I could have sworn when I looked at this question, there were no replies. Then I replied and I see like 8 people have already answered. -- Kevin Vaughn "Kevin Vaughn" wrote: Try reversing the order of b1 and a1. In the test I tried, that's how I got rid of the #num error. Kevin Vaughn "JohnH" wrote: I'm using Excel 2000 and trying to use the datedif function. I've formated 2 columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John -- Kevin Vaughn ------------------------------------------------------------------------ Kevin Vaughn's Profile: http://www.excelforum.com/member.php...o&userid=34857 View this thread: http://www.excelforum.com/showthread...hreadid=551181 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
Multiple or Variable cell references in Solver (Excel 97) | Excel Worksheet Functions | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |