Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
how do you work out how many days there are between 8/8/2008 and 3/9/2010
Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
Sorted
=a1-a2 Format cell to number "MillyD" wrote in message ... how do you work out how many days there are between 8/8/2008 and 3/9/2010 Cheers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
I'm sure you've asked this before. Just subtract the start date from
the end date and it will give you the number of days (format the cell as general). If you want to exclude the dates then subtract 1, if the dates are inclusive then add 1, i.e.: =B1-A1-1 (exclude dates) or =B1-A1+1 (inclusive dates) Hope this helps. Pete On Aug 19, 8:57*am, "MillyD" wrote: how do you work out how many days there are between 8/8/2008 and 3/9/2010 Cheers |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
cheers
"Pete_UK" wrote in message ... I'm sure you've asked this before. Just subtract the start date from the end date and it will give you the number of days (format the cell as general). If you want to exclude the dates then subtract 1, if the dates are inclusive then add 1, i.e.: =B1-A1-1 (exclude dates) or =B1-A1+1 (inclusive dates) Hope this helps. Pete On Aug 19, 8:57 am, "MillyD" wrote: how do you work out how many days there are between 8/8/2008 and 3/9/2010 Cheers |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
You're welcome, Derek.
One would expect BAe Systems workers to know these things ... <bg Pete On Aug 19, 11:59*am, "MillyD" wrote: cheers "Pete_UK" wrote in message ... I'm sure you've asked this before. Just subtract the start date from the end date and it will give you the number of days (format the cell as general). If you want to exclude the dates then subtract 1, if the dates are inclusive then add 1, i.e.: =B1-A1-1 (exclude dates) or =B1-A1+1 (inclusive dates) Hope this helps. Pete On Aug 19, 8:57 am, "MillyD" wrote: how do you work out how many days there are between 8/8/2008 and 3/9/2010 Cheers- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
A/C Engineer not a spread sheet geek
"Pete_UK" wrote in message ... You're welcome, Derek. One would expect BAe Systems workers to know these things ... <bg Pete On Aug 19, 11:59 am, "MillyD" wrote: cheers "Pete_UK" wrote in message ... I'm sure you've asked this before. Just subtract the start date from the end date and it will give you the number of days (format the cell as general). If you want to exclude the dates then subtract 1, if the dates are inclusive then add 1, i.e.: =B1-A1-1 (exclude dates) or =B1-A1+1 (inclusive dates) Hope this helps. Pete On Aug 19, 8:57 am, "MillyD" wrote: how do you work out how many days there are between 8/8/2008 and 3/9/2010 Cheers- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |