Week ending function?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi does anyone know how to create a field within a report
which displays the week ending property - like date()
displays the current date?

Many thanks
Steven
 
You mean to know when Friday is relative to any day?

I think the following is correct (I didn't test it thoroughly)

Function FridayOfThisWeek(WhatDate As Date) As Date

FridayOfThisWeek = DateAdd("d", vbFriday - WeekDay(WhatDate), WhatDate)

End Function
 
Back
Top