Is there a formulae which will work out what weeks numbers..

[bsnapool]

go into the month? For e.g.

If I had a numbers from 1 - 52, this would work out what month this should go into?

E.g

1 > Jan
2 > Jan
3 > Jan
4 > Jan
5 > Feb

Hope this explains it enough, thanks in advance for your help..

Andrew

 

[bsnapool]

They are all named numerically... 1,2,3,4, etc

Tried your formuale and it does not seem to work...?? Coming up with a VALUE error

 

[Oaktree]

Hmm. Are you trying this in an unsaved workbook (working in Book1)? The REPLACE formula part will return a #VALUE! error if the workbook has not been saved...

Otherwise, try selecting everything from the R in REPLACE through the ) after the "" in the formula bar and pressing F9. What is between the quotes?