Amending period for query

[SharpL]

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!

[CK76]

Something like below?

strNLPeriod = CStr(Format(Range("B4").Value - 1, "00"))