Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dates & times are stored as numbers.
Therefore simply subtracting one from the other will give you the tim between two dates. Note however that the date is the integer portio only. If you need look at only the dates and ignore the time portio use INT(a) - INT(b) or to round down to the nearest day int(a - b). Hope it helps -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count specific days in between dates | Excel Discussion (Misc queries) | |||
Count days between text dates | Excel Discussion (Misc queries) | |||
Count of days between dates | Excel Discussion (Misc queries) | |||
Count days inside 2 dates | New Users to Excel | |||
how to count number of days between 2 dates? | Excel Discussion (Misc queries) |