LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't open older .xls files after install 2007 patch sfleck Excel Discussion (Misc queries) 0 October 16th 07 07:54 PM
Calculating first/last Monday, Tuesday, etc. in a given month in E Rossta Excel Worksheet Functions 3 May 27th 06 02:19 AM
Latest Office patch de-registered EXCEL 2002 .Word/PP fine. Ideas BBTim Excel Discussion (Misc queries) 2 April 17th 06 09:44 PM
Is there patch or soln?:When I open a shared doc the option for ". MARIAMnSD_CA Excel Discussion (Misc queries) 1 March 26th 05 12:04 AM
Excel fun patch [email protected] Excel Discussion (Misc queries) 0 March 23rd 05 03:20 AM


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"