Jun 28 2022 01:44 AM
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.
Jun 28 2022 03:35 AM
It could be
F2:
=NETWORKDAYS.INTL(DATE(2022,6,28),H2,1,$L$2:$L$3) +22122
F3:
=F2-1
and apply General format
Jun 28 2022 07:07 AM
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.
Jun 28 2022 02:01 PM
SolutionJun 28 2022 07:43 PM
Jun 28 2022 02:01 PM
Solution