Counting Days Between Dates

N

Niek Otten

Hi Jerry,

YES!

=A1-B1

You see, a date in Excel is a number, representing the number of days since 1-1-1900.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| What is an easy way to count the number of days between two dates? Thanks
| --
| JerryS
 

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

Date Diff - excluding working days 2
Number of Weekend Days between 2 Dates Q 1
AVERAGE BASED ON 2 CRITERIA 1
number of week days in a period of time 5
Count distinct days from two groups of days 3
Excel Formula - Count Dates from another Sheet 8
countif number of nights not days using dates 1
Excel High lightng dates in future, today and past 1

Top