| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days between two dates?
Given two dates, say in the (UK) format dd/mm/yyyy, could one of the
experts define an Excel formula that would return the number of days between them please? -- Terry, East Grinstead, UK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days between two dates?
On Tue, 03 Apr 2012 22:38:44 +0100, Terry Pinnell wrote:
Given two dates, say in the (UK) format dd/mm/yyyy, could one of the experts define an Excel formula that would return the number of days between them please? =date2 - date1 Format as General or as Number |
| 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 | |||
| TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS | Excel Programming | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming | |||
![Terry Pinnell[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
