Forum Discussion
Solved
Batch Numbring
Hi everyone,
I’m in the situation where I have two cells of daily Batch numbers in a column for example:
The cell F2 has the “Current Batch number” and the cell F3 has the “Previous Batch number”. So on June 28, 2022 the “Current Batch number” supposed to be 22123 where as the “Previous Batch number” should be 22122.
The Batch numbers supposed to be increase by 1 on working days (excluding the weekends and the holidays). The holidays are defined in L2 to L16. I will greatly appreciate any help to place the right formula and thanks in advance.
5 Replies
It could be
F2: =NETWORKDAYS.INTL(DATE(2022,6,28),H2,1,$L$2:$L$3) +22122 F3: =F2-1and apply General format
Sergei Baklan, thank you so much for the perfect formula, it serves its purpose greatly. The only thing remaining is the comma at the end which I try to do by &”,”. It shows the comma at the end fine for F2 figure but F3 says #VALUE! I wish if that could be fixed. I thank you so much for your help.
