View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Help finding the date of the last Saturday of a given month

Try this:

=DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,1)+n)

Where n = 1 for Sunday ...........7 for Saturday

Biff

"Chuck M" wrote in message
...
Hi,

I can't get my head around the calculation necessary to find the date of
the
last Saturday in any given month. Any help will be greatly appreciated!

--
Thanks.
Chuck M.