MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to calculate how many days between 2 dates


Posted by Mary on November 10, 2001 3:15 AM

I have two dates 10 oct 01 & 9 Nov 01. How do I calculate the total days between them. I keep getting some date in january. I want it to say 30 days


Posted by Aladin Akyurek on November 10, 2001 4:48 AM

=B1-A1

where B1 >= A1. Format the cell of this formula as General.

Aladin