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.
|