View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PM PM is offline
external usenet poster
 
Posts: 7
Default Calculating Patch Tuesday

Hi,

I need three formulae that use the current date to give the dates of the
last three 'Patch Tuesdays', i.e. the second Tuesday of the month.
So for today (15th Nov) the relevant dates are 13th Nov, 9th Oct, 11th Sep,
but a week ago the results would have been 9th Oct, 11th Sep, 14th Aug.

Anyone?

TIA
Pete