Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
How do i change the (default) first day of the week from Sunday to Monday?...
Thank you, Jay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
Default where? There is nothing that says that Sun is the first day of week
per se except the Weekday function, which can be overcome by using =WEEKDAY(date,2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... How do i change the (default) first day of the week from Sunday to Monday?... Thank you, Jay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
Hi Bob,
Yeah, that is the function I'm trying to use, but our week starts on a Monday. Sorted! Thank you, Jay "Bob Phillips" wrote: Default where? There is nothing that says that Sun is the first day of week per se except the Weekday function, which can be overcome by using =WEEKDAY(date,2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... How do i change the (default) first day of the week from Sunday to Monday?... Thank you, Jay |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
Actually, Bob. It's the WEEKNUB functions that I'm trying to use to give me
the numercial week of the year - it's still one or two days out when it gets to the end of the year. Any thoughts? Jay "Bob Phillips" wrote: Default where? There is nothing that says that Sun is the first day of week per se except the Weekday function, which can be overcome by using =WEEKDAY(date,2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... How do i change the (default) first day of the week from Sunday to Monday?... Thank you, Jay |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
Also, Bob (sorry) I'm using a column of date for the week numbers, so the
fomular is: =WEEKNUM(A1,2) But, if there is no entry yet in Column A, it returns a value of 1. Your thoughts please... Thank you, Jay "Bob Phillips" wrote: Default where? There is nothing that says that Sun is the first day of week per se except the Weekday function, which can be overcome by using =WEEKDAY(date,2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... How do i change the (default) first day of the week from Sunday to Monday?... Thank you, Jay |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
and Weeknum of course <g
=IF(A1="","",WEEKNUM(A1,2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... Also, Bob (sorry) I'm using a column of date for the week numbers, so the fomular is: =WEEKNUM(A1,2) But, if there is no entry yet in Column A, it returns a value of 1. Your thoughts please... Thank you, Jay "Bob Phillips" wrote: Default where? There is nothing that says that Sun is the first day of week per se except the Weekday function, which can be overcome by using =WEEKDAY(date,2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... How do i change the (default) first day of the week from Sunday to Monday?... Thank you, Jay |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the week...
Weeknum(Serialdate,2) will start the week on Monday in 2003 at least.
From Excel Help The WEEKNUM function considers the week containing January 1 to be the first week of the year. However, there is a European standard that defines the first week as the one with the majority of days (four or more) falling in the new year. This means that for years in which there are three days or less in the first week of January, the WEEKNUM function returns week numbers that are incorrect according to the European standard. "Jayjay" wrote: Actually, Bob. It's the WEEKNUB functions that I'm trying to use to give me the numercial week of the year - it's still one or two days out when it gets to the end of the year. Any thoughts? Jay "Bob Phillips" wrote: Default where? There is nothing that says that Sun is the first day of week per se except the Weekday function, which can be overcome by using =WEEKDAY(date,2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... How do i change the (default) first day of the week from Sunday to Monday?... Thank you, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
group sales by week and week number | Excel Discussion (Misc queries) | |||
Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
How do I change from a 7 day week to a 5 day week in Excel? | Excel Discussion (Misc queries) | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |