View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default Find Last Saturday of the Year

On Mar 17, 11:08*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
If you want the last Saturday of the year, given a date in A1, all you need
to do is change the TODAY() in my formula to A1, in other words:
*=DATE(YEAR(A1),1,1)-WEEKDAY(DATE(YEAR(A1),1,1))

I don't know what you think your formula below is doing, but it returns a
Saturday only once every 6 or 7 years. *I'm glad you're happy with it!
--
David Biddulph

"jlclyde" wrote in message

...

David,
Yours goes from TODAY() and not from any year. *It is close though. *I
came up with this one to do last Saturday of the month. *This will get
me close enough.

Thanks,
Jay
=DATE(YEAR(A1),MONTH(A1)+1,0)-
(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,2),1)-5))

On Mar 17, 10:21 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:



=DATE(YEAR(TODAY())+1,1,1)-WEEKDAY(DATE(YEAR(TODAY())+1,1,1))
--
David Biddulph


"jlclyde" wrote in message


...


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 -- Hide quoted text -


- Show quoted text -


David,