Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date functions
is there a way to have excel figure out cetain dates for example the last
saturday of every month for the next year? |
#2
|
|||
|
|||
http://www.cpearson.com/excel/distribdates.htm
Niek Otten "Bonniem" wrote in message ... is there a way to have excel figure out cetain dates for example the last saturday of every month for the next year? |
#3
|
|||
|
|||
On Mon, 10 Oct 2005 14:49:03 -0700, "Bonniem"
wrote: is there a way to have excel figure out cetain dates for example the last saturday of every month for the next year? If you put this formula in A1, and copy/drag down, it will give you the date of the last Saturday in every month starting with Jan 2006: =DATE(2006,ROW()+1,1)-WEEKDAY(DATE(2006,ROW()+1,1)) The portion ROW()+1 denotes the month, and will change automatically as you drag the date down. So if you start, for example, in A5, you would change that to ROW()-4 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Date functions | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Date functions | Excel Discussion (Misc queries) |