Formualu to extract period vbased on values

[Howardc]

Thanks for the help, much appreciated

It would be appreciated if you can explain how this formula works