Today's week number

Originally Posted by kizzie

Hey there,

I have a sheet with one column, indicating the week number for that row. Is there an easy way to chech whether the week number is exceeded, by comparing to the today's week number (1-52)?

thanks in advance
kizzie

Hi,

try

=If(A1>WeekNum(Today()), true , false )

hth
---

but note, on the first of January it will (again) not be.

If you date is in A1, then

=WEEKNUM(A1,1) 1 being if week starts on Sunday, 2 for Monday

to get WEEKNUM to this week

=WEEKNUM(TODAY(),1)

Originally Posted by kizzie

Hey

Does this also work in vba code?

thanks

Hi,

the WeekNum is not available as a WorkSheet function, and there may be a suitable code to get the week, but you can always use the formula option from VB, useful for those processes where the Formula is easier than the code,

Please Login or Register  to view this content.

should help you.

hth
---