Find characters in formula

In the attached file, I am looking for the 2 numbers after the FW in the formula in cells in column G.

Example:
Cell G258 has the formula:

Please Login or Register  to view this content.

I am trying to set a parameter (J in my instance) to equal the 37 in my VBA code, first two digits after the 'Fw'. (Essentially, this is the Fiscal Week - but this can change from site to site - some start in October, others in Jan, sometimes late December, etc), so I need these numbers and not create another application to create the Fiscal Week.

Perhaps

Please Login or Register  to view this content.

Hello mtbe,

Use this UDF (User Defiend Function) in a cell on your worksheet or in your VBA code to return the Fiscal Week number from a cell. If "FW" is found the week number is returned, otherwise a zero is returned.

Please Login or Register  to view this content.

Example - Worksheet Function

Please Login or Register  to view this content.