Offset result in separate cell

[Ric69]

Hoping for some help here if possible?
I have a spreadsheet listing jobs by line, in cells O2 I have the start date and in cell P2. In Cell R2 I have a formula =P2 and have formatted the cell to show 'mmm'.
On the next sheet I have a table with the customers down the left and months of the year across the top. I want the table to shows the number of jobs per customer per month based on data in sheet 1.
However, the formula I have on sheet 2, looks at the month (mmm) across the top and cross matches to the 'mmm' in sheet 1 in column R, but as cells in column R contain formula it is not picking up any data.

I was wondering if I could amend the formula in R2 to do the calculation and then put the result in a 'clean' cell as text, I could then amend my formula in sheet 2 to to cross reference with this 'text' and therefore do the calculation.

To make things more complication, I'm sharing the sheet outside my organisation using oneDrive and intend for the users to view using either chrome or firefox etc which i dont think supports macros / VBA

 

[KOKOSEK]

[...] if I could amend the formula in R2 to do the calculation and then put the result in a 'clean' cell as text,[...]

There is no possible that formula gives result on other cell.