View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dean F Dean F is offline
external usenet poster
 
Posts: 2
Default Find last Sunday

Hi - I'm trying to display data based on the last complete workweek, i.e.
today, the data displayed should be for the week ending Oct. 8. Monday, I
want to display data for the week ending Oct 15. Short of a messy nested 'if'
formula, is there a way to determine the date of the most recent Sunday past?

Thanks