M
MillyD
how do you work out how many days there are between 8/8/2008 and 3/9/2010
Cheers
Cheers
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MillyD
Sorted
=a1-a2
Format cell to number
=a1-a2
Format cell to number
P
Pete_UK
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
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
M
MillyD
cheers
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
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
P
Pete_UK
You're welcome, Derek.
One would expect BAe Systems workers to know these things ... <bg>
Pete
One would expect BAe Systems workers to know these things ... <bg>
Pete
M
MillyD
A/C Engineer not a spread sheet geek
You're welcome, Derek.
One would expect BAe Systems workers to know these things ... <bg>
Pete
You're welcome, Derek.
One would expect BAe Systems workers to know these things ... <bg>
Pete