Forum Discussion

Brass Contributor

Jun 28, 2022

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”. ...

excel

SergeiBaklan
Jun 28, 2022
A2Z CF , you are welcome.

With dots it could be like

SergeiBaklan

Diamond Contributor

Jun 28, 2022

A2Z CF

It could be

F2:
=NETWORKDAYS.INTL(DATE(2022,6,28),H2,1,$L$2:$L$3) +22122

F3:
=F2-1

and apply General format

A2Z CF

Brass Contributor

Jun 28, 2022

SergeiBaklan

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.

SergeiBaklan
Diamond Contributor
Jun 28, 2022
A2Z CF , you are welcome.

With dots it could be like
- A2Z CF
  Brass Contributor
  Jun 29, 2022
  Sergei Baklan, thank you so much for your help, I appreciate it very much. It works really great and resolved my issues. It's so much easy and accurate now. May the power be with you. Thanks alot!
  - SergeiBaklan
    Diamond Contributor
    Jun 29, 2022
    A2Z CF , thank you, glad to help