Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate dates
I would like my spreadsheet to tell me what the dates are for the Thursdays
in a specified month. i.e - I will input May 2006, I would like it to then show me each Thursday, each in their own cell. 1st Thurs=05/04/06, 2nd Thurs=05/11/06, etc. Thank you, Carla |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate dates
Put May 2006 in A1, then put this formula in A2 and copy down
=DATE(YEAR($A$1),MONTH($A$1),1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR($A$1),MONTH($A$1),8-5)) this assumes that when you put May 2006 in A1 it will show as 5/1/2006 or whatever region setting your date formats use -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Carla" wrote in message ... I would like my spreadsheet to tell me what the dates are for the Thursdays in a specified month. i.e - I will input May 2006, I would like it to then show me each Thursday, each in their own cell. 1st Thurs=05/04/06, 2nd Thurs=05/11/06, etc. Thank you, Carla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to calculate the nuber of weeks between dates? | Excel Worksheet Functions | |||
Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
How do I calculate # of weeks between 2 dates in excel? | Excel Worksheet Functions | |||
How to Calculate Dates without counting the weekends | Excel Worksheet Functions |