Hi,

I have two worksheets and I'm trying to enter a function into the second
worksheet based on data in the first. They are based on recruitment activity,
e.g. how long it takes to fill a vacancy, the candidate source, etc.

Column P, "Offered" is simply a date (format d-mm-yy).
Column S, "Time to Fill" is a "Days360" function based of the date the
vacancy was received and the "Offered" date.

In the second workshop I want to create a function that will calculate the
average Time to Fill for any role offered in a particular month.

Please can someone help me! If necessary I can send you the spreadseet to
review.

Thanks!