Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Make an Excel series of first and third fridays of each month?
I am Using Excel 2000. I want to be able to create an arbitrary series of
dates and extend that by dragging the series across a years worth of cells. For example, I enter the first and third fraiday's of January, then drag that out to December to create a series of the first and third fridays of every month. |
#2
|
|||
|
|||
Hi Elliot,
By trial and error I found that every 1st and 3rd xxxday of every month follow the interval sequence of (beginning on the first xxxday in jan 2005) is: 01-dd-2005 (your first xxxday) first 14 days (your third xxxday) then 21 days (the first xxx, next month) next 5 times 14 days again 21, 5 times 24, ... So 14-21-14-14-14-14-14-21 Or 2-3-2-2-2-2-2-3 * 7 You copy through the 14-14-14-14-14-21 sequence by using <Ctr-drag the fill handle. Then use formulas to create the dates. I know this is not full proof. Starting with 01-01-2005, you will get 12-21-2005 in the sequence because a year has 365 days i.s.o. 364 (# * 14). Things go wrong when you try to find every 2nd and 4th. And it will break in the first leap year to come: 2008. Still I hope this helped a bit. It puzzles me and I would be in favor of "Captains log, star date 3563542,889" ... decimal dates. Frans "Elliot" wrote in message ... I am Using Excel 2000. I want to be able to create an arbitrary series of dates and extend that by dragging the series across a years worth of cells. For example, I enter the first and third fraiday's of January, then drag that out to December to create a series of the first and third fridays of every month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|