Jan 1 Always Week 1

[#1]

can you give me a script on how to set

Jan 1 is always Week 1 every Year

thank you

[tresB]

Hello,

Have you tried week function?

Thanks.

[sushil353]

Hi,

try this:

get the month start date from monthstart() and then subtract 7 days from that.

HTH

Sushil

[#4]

you can use

Div(date-YearStart(date)+WeekDay(YearStart(date))+7,7) as WeekNumber

This will always return week 1 for Jan 1st. It will use Monday as the first day of the week.

If you want Sunday as the first day of the week, you should use

   Div(date-YearStart(date) + WeekDay(YearStart(date)+1) +7,7) as WeekNumber

[jagan]

Hi,

Try LunarWeekName()

=Right(LunarWeekName(MakeDate(2012, 1)), 2)

Hope it helps you.

Regards,

Jagan.