| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count days between text dates
Why can't you change the dates to numbers?
One method for doing so. Select A1 and DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Same for B1 Gord Dibben MS Excel MVP On Tue, 11 Aug 2009 08:18:01 -0700, Benny wrote: Hello, I need to count the number of days between dates also the months are in spelled out. I can't change them to numbers. So, is there a way to count days if cell A1 is Sep/5/2008 and cell B1 is Oct/25/2009? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of dates falling in the next seven days | Excel Worksheet Functions | |||
| 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) | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
Hybrid Mode
