Week Number Function

[wetweb]

I am working on a timesheet function. I would like to select th
timesheet period based on the week number. Not sure if this is the bes
way. But all I am trying to do is get the Saturday (weekendings) mayb
even from a dropdown list would be nice to populate the whole yea
current or future. But start out by using the current period.

Currently attempting to use the following

Retrieving Saturday (week ending)
=TODAY()+7-WEEKDAY(TODAY(),1)

Retrieving the week number
=TRUNC(((TODAY()-DATE(YEAR(TODAY()),1,0))+6)/7)

What I would like to do is setup some sort of IF.

Such as if week is odd go to Saturday. If even add 14 days till th
next period ending

 

[Daniel.M]

Hi,

If you intend to find every other Saturday that is current/next to Today.

=CEILING(TODAY(),14)

'also for the _other_ Saturday

=CEILING(TODAY()-7,14)+7

Note that this formula is working with 1900 calendar only. Advise if you're
using 1904 calendar.

Regards,

Daniel M.