I have this line listed as the control source.
="( " & Format([Date],"dddd") & " Week " & DatePart("ww",[Date]) & " )" & DatePart("ww","12/31/" & [year])
The last DartPart shown in red does not work.
What I am trying to do is get it to display the following:
"Monday Week 6 of 53."
The only thing is that every now and then you will hit a week 54.
Any ideas on how to get this to work correctly??
="( " & Format([Date],"dddd") & " Week " & DatePart("ww",[Date]) & " )" & DatePart("ww","12/31/" & [year])
The last DartPart shown in red does not work.
What I am trying to do is get it to display the following:
"Monday Week 6 of 53."
The only thing is that every now and then you will hit a week 54.
Any ideas on how to get this to work correctly??