Determining what the week number is

[dsmart16]

Help,

Hi there, is there a formula that figures out what the week number is based on a date that the user enters

I've got two text boxes
txtDate
txtWeekNumber

When the user enters in the date, I want the week number to automatically display ... if possible.

Thanks
Dave

 

[TheAceMan1]

How are ya dsmart16 . . . . .

There's [blue]alot of controversy[/blue] about WeekNumber. Companies use it differently, what constitutes the first week of a year and so on.

The [purple]Format[/purple] function calculates a decent WeekNumber. In the [blue]ControlSource[/blue] of [purple]txtWeekNumber[/purple], copy/paste the following:

[blue]   = Format([txtDate],"ww")[/blue]

For a [blue]more absolute function[/blue] see the link below (at the bottom):

Determine Week Number from Date

See Ya! . . . . . .