Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A tough problem
I have a workbook with 4 Worksheets
June - August September - November December - February March - May Across the top of each worksheet I need the date of the 2nd and 4th Tuesday of each month (June - August, September - November ect). Now I know I can just sit down and enter this manually, but I want this to automatically update depending on the year which I have entered in cell A1. I am at a loss for how to do this, so any of you miracle workers out there have any ideas? |
#3
|
|||
|
|||
even more
http://tinyurl.com/9l2ld -- Don Guillett SalesAid Software "Patrick Simonds" wrote in message ... I have a workbook with 4 Worksheets June - August September - November December - February March - May Across the top of each worksheet I need the date of the 2nd and 4th Tuesday of each month (June - August, September - November ect). Now I know I can just sit down and enter this manually, but I want this to automatically update depending on the year which I have entered in cell A1. I am at a loss for how to do this, so any of you miracle workers out there have any ideas? |
#4
|
|||
|
|||
On Sat, 30 Jul 2005 09:38:55 -0700, "Patrick Simonds"
wrote: I have a workbook with 4 Worksheets June - August September - November December - February March - May Across the top of each worksheet I need the date of the 2nd and 4th Tuesday of each month (June - August, September - November ect). Now I know I can just sit down and enter this manually, but I want this to automatically update depending on the year which I have entered in cell A1. I am at a loss for how to do this, so any of you miracle workers out there have any ideas? With the year in A1, (and Mnth=the number of the month) the second Tuesday of any given month is given by the formula: =DATE(A1,Mnth,15)-WEEKDAY(DATE(A1,Mnth,12)) The 4th Tuesday would be the above +14 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Tough problem with rotas | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |