MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Figuring the number of days


Posted by Debbie on January 28, 2002 2:32 PM

I am doing an excel spreadsheet and need to figure the number of days between 2 dates using a 365 day calendar year. All I can see in the options for excel is the 360 day calendar.

Please advise.

Thanks
Deb


Posted by Aladin Akyurek on January 28, 2002 2:40 PM

=B1-A1 or =B1-A1+1 (where B1 > A1)? [NT]