M
Mathew
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
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