Count date

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
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