Find Last Saturday of the Year
On Mon, 17 Mar 2008 07:42:23 -0700 (PDT), jlclyde
wrote:
I am trying to find the last Saturday of the year with excel. There
are a few sites that I visited, but they specify weekdays and I want
saturday.
Thanks,
Jay
Last day of "this" year:
=DATE(YEAR(TODAY()),12,32)-WEEKDAY(DATE(YEAR(TODAY()),12,32))
Last day of year in A1 (where A1 contains the Year: e.g. 2007, 2008, etc)
=DATE(A1,12,32)-WEEKDAY(DATE(A1,12,32))
Last day of year in A1 where A1 contains a full date (e.g. 3/5/2008)
=DATE(YEAR(A1),12,32)-WEEKDAY(DATE(YEAR(A1),12,32))
--ron
|