Try this

=INT((H1-(DATE(2010,4,1)-WEEKDAY(DATE(2010,4,1),2)+1)+7)/7)

--

HTH

Bob

"George" wrote in message
...
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