datepart question
 

can someone explain what i am seeing?

this expression returns 4
DatePart("w", DateSerial(2009, 1, 1), vbMonday, vbFirstFullWeek)

the 1st is on thursday and the first monday is the 5th, which is 4 days later.

but this expression returns 6, which doesn't make sense to me. i would think it
would return 3
DatePart("w", DateSerial(2010, 1, 1), vbMonday, vbFirstFullWeek)

so, i guess i'm missing something.


--


Gary

datepart question
 

Contrary to what the help file says, I don't think the 4th argument has any
bearing on the return value from the DatePart function when the first
argument is "w" (try all the possible arguments for the 4th argument... for
a given date and start of week, you will always get the same value). Now, as
to what the function is returning... I don't think it is doing what you seem
to think it is. With the "w" argument, it is giving you the weekday number
of the date you provide with the count starting as indicated by the 3rd
argument. So, for this...

DatePart("w", DateSerial(2009, 1, 1), vbMonday, vbFirstFullWeek)

it returns 4 because the January 1, 2009 occurs on a Thursday which is the
4th day of the week when the week starts on Monday (Monday is 1, Tuesday is
2, Wednesday is 3 and Thursday is 4). As for this...

DatePart("w", DateSerial(2010, 1, 1), vbMonday, vbFirstFullWeek)

you said it returns 6, but actually, it returns 5 and that is because
January 1, 2010 occurs on Friday and Friday is the 5th day of the week when
the week starts on a Monday.

--
Rick (MVP - Excel)


"Gary Keramidas" <GKeramidasAtMsn.com wrote in message
...
can someone explain what i am seeing?

this expression returns 4
DatePart("w", DateSerial(2009, 1, 1), vbMonday, vbFirstFullWeek)

the 1st is on thursday and the first monday is the 5th, which is 4 days
later.

but this expression returns 6, which doesn't make sense to me. i would
think it would return 3
DatePart("w", DateSerial(2010, 1, 1), vbMonday, vbFirstFullWeek)

so, i guess i'm missing something.


--


Gary

datepart question
 

thanks, rick. i mistyped and the 6 should have been 5.

--


Gary

"Rick Rothstein" wrote in message
...
Contrary to what the help file says, I don't think the 4th argument has any
bearing on the return value from the DatePart function when the first argument
is "w" (try all the possible arguments for the 4th argument... for a given
date and start of week, you will always get the same value). Now, as to what
the function is returning... I don't think it is doing what you seem to think
it is. With the "w" argument, it is giving you the weekday number of the date
you provide with the count starting as indicated by the 3rd argument. So, for
this...

DatePart("w", DateSerial(2009, 1, 1), vbMonday, vbFirstFullWeek)

it returns 4 because the January 1, 2009 occurs on a Thursday which is the 4th
day of the week when the week starts on Monday (Monday is 1, Tuesday is 2,
Wednesday is 3 and Thursday is 4). As for this...

DatePart("w", DateSerial(2010, 1, 1), vbMonday, vbFirstFullWeek)

you said it returns 6, but actually, it returns 5 and that is because January
1, 2010 occurs on Friday and Friday is the 5th day of the week when the week
starts on a Monday.

--
Rick (MVP - Excel)


"Gary Keramidas" <GKeramidasAtMsn.com wrote in message
...
can someone explain what i am seeing?

this expression returns 4
DatePart("w", DateSerial(2009, 1, 1), vbMonday, vbFirstFullWeek)

the 1st is on thursday and the first monday is the 5th, which is 4 days
later.

but this expression returns 6, which doesn't make sense to me. i would think
it would return 3
DatePart("w", DateSerial(2010, 1, 1), vbMonday, vbFirstFullWeek)

so, i guess i'm missing something.


--


Gary