Good Afternoon All,



This is my second posting of this query. I did get some help, from Bob using

=INT(C3/7)+1 in Col A, (Thanks Bob), but it did not quite work for all
cases,

eg if $A$1 is 1st August 08, where the 1st is a Friday (week1), but the
following

Monday (the 4th) comes out as week 1 also, where it is supposed to be week
2.

Thanks to some help received here on my thread - Name The Date2 - I now need
to be able to name the Week in the month (ie 1-5) that the Day (Mon/Tues...)
falls in.
Example Spreadsheet below

A B C
1 = Today()
2 Week No Day Date (Header Row)
3 Tue 01
4 Wed 02
5 Thu 03
6 Fri 04



Etc Etc Etc


The Formula In Column B3 & copied down is
=TEXT(DATE(YEAR($A$1),MONTH($A$1),TRIM(C3)),"DDD")
which gives the Day of the date in Column C
Now in Column A, I would like a way to name the week of the month, ie 1 to
5. In this case the first Monday (the 7th) would be in Week2, but the
formulae I have tried, (including combinations of IF statements don't seem
to work, as only can nest 7), want to use the dates 01-07 as Week1, which is
obviously incorrect in this case.
I am trying to summarize all my company's direct debits, but have found it
difficult as the DAYS of the month fall on Different DATES of the month.
I hope I have explained this okay, and the formatting works when I post it!

As usual, any help is most appreciated.
Cheers
Mathew