Apologies, 10 would be number of days and £22 is in another cell but with other data, I basically have:
Normal days @ £22, in one cell
number of days in one cell
So I can't really do the basic a1*b1 calculation and I also need a variance in the calculation of 1 to 31 for the number of days.
Hope that makes sense.