Date
 

How to get count date if A1 = 7/10/06 and B1 = 7/23/06 and count days be in
C1 as 14 days not 13 days? Need count 7/10/06 as a day too!

Date
 

Just use

=B1-A1+1

format as general


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564139

Date
 

Thanks longlegs!

"daddylonglegs" wrote:


Just use

=B1-A1+1

format as general


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564139