dates
 

how do you work out how many days there are between 8/8/2008 and 3/9/2010

Cheers

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

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

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

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 -

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 -