excel dates

[mikey]

how do i show 01/01/00 minus 31/01/00 as 31 days and not 30 :

 

[David McRitchie]

Hi Mikey,
b2: 01/01/00 dd/mm/yy format
C2: 31/01/00 dd/mm/yy format
d2: =C2-B2+1 # format [inclusive dates, not difference)