Tried the VBA function, but couldn't get it to compile, although, I'

not sure if it would have returned what i needed.

This has turned out to be tougher to describe than I thought it woul

be. Now that I think about it, this may not be doable in excel. Let m

know if whit I am trying to do is impossible.

Let me try to explain more fully.

My company's year always has 52 weeks, that always start on Monday

2004 began on 12/29/03, and the fiscal year 2005 will begin o

12/27/04.

I would like to have a formula that, based on a reference date, woul

return the period number and week number of that period.

For instance, for the reference date 7/19/04, I would like it to retur

"Period 7 - Week 4"

As a bonus, if I could have another formula that could tell if th

period has 4 or 5 weeks would be great.

thanks

darro

--

Message posted from

http://www.ExcelForum.com