MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculating the number of daysd between 2 dates


Posted by John on July 13, 2001 5:49 AM

How do I calculate the total number of days betweeen to cell which are date formatted e., 3/7 - 5/7 should return 2, but instead I get a long string of numbers.

The dates e.g. 3/7 are date formatted


Posted by Aladin Akyurek on July 13, 2001 6:12 AM

=B1-A1

where B1 contains more recent date.

Format the cell where you put this formula as number.

Aladin