Please give us more. You seem to have two cheques with number 4480
Is this a typo or is 44481 the example of a missing cheque
What does this mean: Now I want the Missing Cheque no.'s by considering the
Dates
Is there a blank in that column when the cheque is 'missing'?
OR do you want to know how many cheques have dates that are after 03/04/08,
how many after 04/03/08, etc
Sorry to be dense
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kumar" wrote in message
...
I Want to know the Missing Cheque no.'s according to the date and my data
is
as Follows:-
A B
03-04-2008 44479
04-04-2008 44480
05-04-2008 44480
04-04-2008 44482
05-04-2008 44483
Here "A" Column Contains the Cheque date and B Column Contains Cheque no.,
Now I want the Missing Cheque no.'s by considering the Dates. Can any one
help me with a Formula...