Hello!

I need some help amending an extract of VBA coding.

The below extract attains the period from cell B4, for my query.

strNLPeriod = CStr(Format(Range("B4"), "00"))
However, I need it to read "B4 minus 1".

For example, if B4 = 4, then period would be 3.

Thanks in advance!