| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Determine the 3 of days between two dates
Have to determine the number of days between two dates
exmple: 1/1/98 and 3/31/98 = #days Thanks -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Determine the 3 of days between two dates
one way is to use the Int() worksheet function.
A1: 1/15/2007 A2: 1/30/2007 B2: = INT(A2-A1) Merjet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Determine the 3 of days between two dates
If in different cells, simply subtract one from the other
-- Don Guillett SalesAid Software "QuietMan" wrote in message ... Have to determine the number of days between two dates exmple: 1/1/98 and 3/31/98 = #days Thanks -- Helping Is always a good thing |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Determine the 3 of days between two dates
And format as General, not as Date (which is what Excel does automatically)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Don Guillett" wrote in message ... | If in different cells, simply subtract one from the other | | -- | Don Guillett | SalesAid Software | | "QuietMan" wrote in message | ... | Have to determine the number of days between two dates | | exmple: 1/1/98 and 3/31/98 = #days | | Thanks | -- | Helping Is always a good thing | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Calculation to determine days between two dates | Excel Worksheet Functions | |||
| Range of dates determine days | Excel Worksheet Functions | |||
| Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming | |||
Linear Mode
