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 -