Day count formula (for Specific date)

[akber.431]

Can anyone help me in the below query

i have some info about Br No. & dates i want to apply the formula days count

for eg.


Br No. Date Required formula for (count days)
1109 11-Aug-10 (Day - 1)
1112 11-Aug-10 (Day - 1)
1113 11-Aug-10 (Day - 1)
1109 12-Aug-10 (Day - 2)
1112 12-Aug-10 (Day - 2)
1113 12-Aug-10 (Day - 2)
1109 13-Aug-10 (Day - 3)
1112 13-Aug-10 (Day - 3)
1113 13-Aug-10 (Day - 3)

reply to this query will be highly appreciable

 

[anandvarma]

try this

Excel Workbook
	A	B	C
1	Br.No	Date	Required
2	1109	11-Aug-10	Day - 1
3	1112	11-Aug-10	Day - 1
4	1113	11-Aug-10	Day - 1
5	1109	12-Aug-10	Day -2
6	1112	12-Aug-10	Day -2
7	1113	12-Aug-10	Day -2
8	1109	13-Aug-10	Day -3
9	1112	13-Aug-10	Day -3
10	1113	13-Aug-10	Day -3
Sheet2

 

[akber.431]

Thanks for reply

but my query has not solved

if possible can you understand the problem

when i apply the formula of yours in my excel sheet it works but i need something different

for eg.

date 12-31/aug it was ok when it reach to 01sep it starts with day 1


my requirement

11-08-2010 day -1

-
-
-
-09-09-2010 Day -30

 

[anandvarma]

try this

Excel Workbook
	A	B	C
2	1109	11-Aug-10	Day - 1
3	1112	11-Aug-10	Day - 1
4	1113	11-Aug-10	Day - 1
5	1109	12-Aug-10	Day -2
6	1112	12-Aug-10	Day -2
7	1113	12-Aug-10	Day -2
8	1109	13-Aug-10	Day -3
9	1112	13-Aug-10	Day -3
10	1113	13-Aug-10	Day -3
11	1113	15-Aug-10	Day -4
12	1113	18-Aug-10	Day -5
13	1113	18-Aug-10	Day -5
14	1113	31-Aug-10	Day -6
15	1113	01-Sep-10	Day -7
16	1113	02-Sep-10	Day -8
17	1113	03-Sep-10	Day -9
18	1113	04-Sep-10	Day -10
19	1113	05-Sep-10	Day -11
20	1113	06-Sep-10	Day -12
21	1113	06-Sep-10	Day -12
22	1113	08-Sep-10	Day -13
23	1113	09-Sep-10	Day -14
24	1113	10-Sep-10	Day -15
Sheet2

 

[akber.431]

Thanks once again
but its not working (from 10thd day)

please give me an easy formula for that