Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting date to numerical and doing calculations
Does anyone know how to convert a date into a single number so that you
can do calcuations with it? For example, Nov,2005 minus January, 2004 equals 23. |
#2
|
|||
|
|||
I'm guessing that you are counting months between two dates, right?
Take a look at Chip Pearson's site about dates and date calculations: http://www.cpearson.com/excel/datedif.htm "Teddy" wrote: Does anyone know how to convert a date into a single number so that you can do calcuations with it? For example, Nov,2005 minus January, 2004 equals 23. |
#3
|
|||
|
|||
Dates ARE stored as numbers, specifically the number of elapsed days since Dec
31, 1899. If you want the difference in months, you can use the undocumented DATEDIF function: =DATEDIF(A1,B1,"m") On 5 Oct 2005 12:58:43 -0700, "Teddy" wrote: Does anyone know how to convert a date into a single number so that you can do calcuations with it? For example, Nov,2005 minus January, 2004 equals 23. |
#4
|
|||
|
|||
dates are actually stored as normal numbers for instance a2 has 23/01/2005 a1 has 12/11/2004 both formatted as dates if you would copy paste and format the pasted cells as numbers you see that 23/01/2005 is now 38375 and 12/11/2004 is 38303 in a3 enter =a2-a1 formatted as number result 72 in a4 enter =a1-a2 formatted as number result -72 if result is ############### then the cell is still formatted as a date and you have a negative "date" -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=473575 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|