Hi
I am looking for a formula that will generate a month and week number from a date. So today's date is 02/02/13 which is January Week 5. So I just need it to say Jan 5. Is this possible? Monday would be the start of the week.
Thank you!
Hi
I am looking for a formula that will generate a month and week number from a date. So today's date is 02/02/13 which is January Week 5. So I just need it to say Jan 5. Is this possible? Monday would be the start of the week.
Thank you!
when does week 1 start? ist day of year or the first monday in year? or the Monday of the first week of the calendar year with a Thursday?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Apologies, the first Monday of the year.
see http://blogs.office.com/b/microsoft-...-in-excel.aspx
which system do you use?
2010. I tried the formula in the link but it just generates the week number?
which formula did you go with?
if you used weeknum then try
=TEXT(DATE(YEAR(A1),1,1)+((WEEKNUM(A1,1)*7)-7),"mmm ")&WEEKNUM(A1,1)
Last edited by martindwilson; 02-03-2013 at 07:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks