Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3
days |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
Hi,
In cell C1, enter B1-A1. Assuming 7/11/2008 is in cell B1 and the other date is in cell A1. Format C1 as general -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "difference between the dates ex: 4/11/2" <difference between the dates ex: wrote in message ... how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3 days |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
=A2-A1+1
-- __________________________________ HTH Bob "difference between the dates ex: 4/11/2" <difference between the dates ex: wrote in message ... how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3 days |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
You may want to skip the +1, Bob?
-- David Biddulph "Bob Phillips" wrote in message ... =A2-A1+1 "difference between the dates ex: 4/11/2" <difference between the dates ex: wrote in message ... how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3 days |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
Hi
If the earlier date is in cell A1, and the later date in cell B1 =B1-A1 Format the cell with the formula as General. If you want to enter dates in the formula, you need to enclose the dates within double quotes ="07/11/2008"-"04/11/2008" and give the later date first. Rather than typing dates it is better to use the Date function =DATE(2008,11,7)-DATE(2008,11,4) -- Regards Roger Govier "difference between the dates ex: 4/11/2" <difference between the dates ex: wrote in message ... how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3 days |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Final Days 2008 East Coast U S Excel User Conference | Excel Discussion (Misc queries) | |||
Final Days 2008 East Coast U S Excel User Conference | Excel Worksheet Functions | |||
(Fussball Spiel EM 2008) [1/3] - "Fussball Spiele EM 2008.sfv" yEnc (1/1) | Excel Discussion (Misc queries) | |||
(Fussball Spiel EM 2008) [2/3] - "Fussball Spiele EM 2008.par" yEnc (1/1) | Excel Discussion (Misc queries) | |||
Problems with using 2008 in dates | Excel Discussion (Misc queries) |