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


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