dates

  • Thread starter Thread starter MillyD
  • Start date Start date
M

MillyD

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

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need difference in Hrs.mm.ss 3
Keep unique values 1
Time difference across midnight PT 2 1
Slope 1
How to get slope 1
average if with time and date 0
Calculate the difference betwen two columns -two dates 3
Attempting to compare and deduct values based on date codes 3

Back
Top