Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function
how can i count the days between 2 dates
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
function
excel
To start with you would just subtract the two dates. Need more information to give a more complete answer. Mike Rogers "excel" wrote: how can i count the days between 2 dates |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
function
=A1-B1
-- Regards, Fred "excel" wrote in message ... how can i count the days between 2 dates |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
function
To add to the answers you have already received, if the two dates are
already in A1 and B1 when you enter the formula, Excel will try to format the formula cell as a date. Simply reformat as General or a number. "Fred Smith" wrote in message ... =A1-B1 -- Regards, Fred "excel" wrote in message ... how can i count the days between 2 dates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |