Help finding the date of the last Saturday of a given month
sorry that should read
=eomonth(A1)-weekday(A1)
--
_______________________
Naz,
London
"Naz" wrote:
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.
|