View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Naz Naz is offline
external usenet poster
 
Posts: 85
Default Help finding the date of the last Saturday of a given month

hi chuck try

=A1-WEEKDAY(A1)

where A1 is the date


--

_______________________
Naz,
London


"Chuck M" wrote:

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.