Counting the number of days between two date

M

Maddoktor

Hi all,

I was wondering if someone could help me by providing the formula to count
the number of days between two dates. i.e. 1/6 to 2/6 ... by subtracting one
from another the answer will be 1. I would like for the formula to count the
first date (1/6) and then count the days. Therefore, the answer to the
number of days from the 1/6 to 2/6 equals 2 (including 1/6).

Thanks in advance.
 

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

Formula to display Count of Days in given month, using list of Startand End Dates 1
Counting years 2
Excel Formula - Count Dates from another Sheet 8
Complicated Formula Problem 10
Couting rows based on given data range 1
Get Number of Date between two date but not include Saturday/Sunday 1
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
formula to count matching days between two date ranges (for largelist of names) 2

Top