Nope, I don't see it either. This seems to happen a lot, I often see a guy
thanking a response when I gave the self same response hours earlier. It
seems to be something to do with the Microsoft web forum.

--

HTH

Bob

"Rick Rothstein" wrote in message
...
Hmm, I don't see any posting in this thread by "Gary Brown"... am I the
only one not seeing that response?

--
Rick (MVP - Excel)



"George" wrote in message
...
Gary, Thank You .....Works Perfect..

"Gary Brown" wrote:

Assuming the 'Start' year is in Cell A1 and the date you want to check
is in
A2...
=ROUNDUP(((A2-MOD(A2-2,7)-DATE($A$1,4,1))/7)+1,0)

So...
Cell A1 = 2010
Cell A2 = 04/01/2010
The formula above will return a '1'

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"George" wrote:

Good Day,

I've search for the solution to this including Cpearson's site but
can't
figure this out..Our Fiscal year begins April 1st every year
regardless of
the day of the week it falls on. So here's my delima, if it falls on
any day
other than a Monday I need to be able to recognize a short week as
week 1
ending on Sunday and week 2 beginning on the 1st Monday after and each
week
following run Monday - Sunday.

Example for this year

Thurs,4-1-2010 thru Sun 4-4-2010 = Week 1
Mon,4-5-2010 thru Sunday,4-11-2010 = Week 2
and so on

Thank you in advance for taking time to look at my issue.
Respectfully,
George