Home |
Search |
Today's Posts |
#1
|
|||
|
|||
difference betwwen two dates in days
I'm using Excel 2002 and i would like to calculate the difference between two
dates in days not in workdays. Unfortunately the help only give you how to do it in workdays. Thank you for your help |
#2
|
|||
|
|||
difference betwwen two dates in days
If there are dates in both A1 and B1, =A1-B1 will provide the number of days
between the two, just make sure you format the cell that contains the formula as a number. ************ Anne Troy www.OfficeArticles.com "seven" wrote in message ... I'm using Excel 2002 and i would like to calculate the difference between two dates in days not in workdays. Unfortunately the help only give you how to do it in workdays. Thank you for your help |
#3
|
|||
|
|||
difference betwwen two dates in days
Hi!
Just subtract! A1 = 10/17/2005 B1 = 12/31/2005 =B1-A1 Format the cell as GENERAL Biff "seven" wrote in message ... I'm using Excel 2002 and i would like to calculate the difference between two dates in days not in workdays. Unfortunately the help only give you how to do it in workdays. Thank you for your help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference betwwen two dates in days
"seven" wrote: I'm using Excel 2002 and i would like to calculate the difference between two dates in days not in workdays. Unfortunately the help only give you how to do it in workdays. Thank you for your help |
#5
|
|||
|
|||
Quote:
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference betwwen two dates in days
Hi
=A1-B1 , where A1 and B1 contain your dates, and format the result as number or general -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "xlEnt" wrote in message ... seven Wrote: I'm using Excel 2002 and i would like to calculate the difference between two dates in days not in workdays. Unfortunately the help only give you how to do it in workdays. Thank you for your help Your question is not clear, please elaborate -- xlEnt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
difference between two dates in years, months and days. | Excel Worksheet Functions | |||
Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions |