How to skip Sundays while adding data in an Excel sheet

I have a date in column "A" like 01-01-2016, 02-01-2016, 03-01-2016 etc. In column "B" I have batch numbers against each date. Normally the batch number starts with 001 at the beginning of the year and running through the year with an increment 1 skipping Sundays. I did manually. Please help me the formula.

01-01-2016 001
02-01-2016 002
03-01-2016
04-01-2016 003
05-01-2016 004
06-01-2016 005
07-01-2016 006
08-01-2016 007
09-01-2016 008
10-01-2016
11-01-2016 009
12-01-2016 010
...
...
...

Sorry I forget to add the attachement.

I need help on that file

Originally Posted by Richard Buttrey

Hi,

It is incumbent on you when asking a question and offering an example that the information you give us accurately reflects your production workbook. Otherwise we all end up wasting a lot of time.

In this case the file you've attached contains a completely different data set layout to the one you first mentioned. Furthermore there is at least one seeming inconsistency since your batch number 049 is repeated in columns D & F

Please explain clearly exactly what is your requirement. I'm assuming the Batch 49 is an error but do tell us before we waste more time.

Apologies, not to explain clearly. Instead of having the whole year in a single column I have formatted in a monthly format to suit in a single page printout.

the file is which I have uploaded is with errors, just to understand my requirement. Please ignore the errors, and once again apologies for wasted all of your valuable time.

Originally Posted by Richard Buttrey

In B7 copied down

Formula:

Please Login or Register  to view this content.

In D7 and alternate columns copied down

=IF(C7<>"",I

Formula:

Please Login or Register  to view this content.

Excellent, works fine. Thanks a lot