G Guest Jun 27, 2006 #1 Any one know how to find a given date for a Sunday or a Satruday in a given week number?
G Gina Whipp Jun 27, 2006 #2 Barry, Sunday: [YourDateField]-Weekday([YourDateField])+1 Saturday: [YourDateField]-Weekday([YourDateField]) WeekNumber: Format([YourDateField],"ww") Hope that helps! Gina Whipp
Barry, Sunday: [YourDateField]-Weekday([YourDateField])+1 Saturday: [YourDateField]-Weekday([YourDateField]) WeekNumber: Format([YourDateField],"ww") Hope that helps! Gina Whipp
