Forum Discussion
Solved
Formula adjustment
Hi Everyone, My serial number which increases by 1 on every workday is not resetting. Here’s what I got: in A3 =TODAY() in A4 =NETWORKDAYS.INTL(DATE(2022,6,23),A3,1,$A$7:$A$18) +22119 ...
- if I understand correctly that formula isn't going to do that (and apparently it isn't)
you need something like:
=(year(A3)-2000)*1000+NETWORKDAYS.INTL(DATE(year(A3),1,1),A3,1,$A$7:$A$18)
as this will change each day I assume you either just use this to copy and paste or maybe a macro uses it?
if I understand correctly that formula isn't going to do that (and apparently it isn't)
you need something like:
=(year(A3)-2000)*1000+NETWORKDAYS.INTL(DATE(year(A3),1,1),A3,1,$A$7:$A$18)
as this will change each day I assume you either just use this to copy and paste or maybe a macro uses it?
you need something like:
=(year(A3)-2000)*1000+NETWORKDAYS.INTL(DATE(year(A3),1,1),A3,1,$A$7:$A$18)
as this will change each day I assume you either just use this to copy and paste or maybe a macro uses it?
- That was it! Thank you so much for this great formula. It works really great, and I appreciate it very much. Thank you
