Monday as a Date Value

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hi,

I run these weekly reports and at the top I want it to
say Week Of and then whatever the most current Monday
would be. So all week long it would say Week Of 11-1-04
until next monday when it would say Week Of 11-8-04. Can
anyone help?

Thanks,

Chuck
 
Chuck

I think this will do it...
="Week Of " & Format(Date()-Weekday(Date(),2)+1,"mm\-d\-yy")
 
Back
Top