On Mar 17, 10:02*am, Pete_UK wrote:
Try this:

=DATE(2008,12,31)-WEEKDAY(DATE(2008,12,31))

or if you have a year in A1:

=DATE(A1,12,31)-WEEKDAY(DATE(A1,12,31))

Hope this helps.

Pete

On Mar 17, 2:42*pm, 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- Hide quoted text -

- Show quoted text -

Pete,