Count date

Closed
niwa - May 28, 2009 at 02:40 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 05:07 AM
Hello,
i want count the date for data range pls give me a formula
ex 02/05/09- 03/05/09 count 2 day

1 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 28, 2009 at 05:07 AM
Suppose you Start Date is in A1 and Finish Date in B1 then formula in C1 will be

C1 = (B1-A1)+1 and make sure to change the cell format of C1 as General or number format

0