I'm trying to create a formula to retrieve the final day of the week depending upon the day the report is open. Here is the formula I used when it was in an excel sheet, where A1 is today's date. Can you tell me how to do this in Access?
=IF(WEEKDAY(A1)=7,A1,A1+(7-WEEKDAY(A1)))