Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
I need to calculate the (for example) first Wednesday of every month, given
the date April 5, 2006 is entered in a cell. How do I calculate the new date, the first Wednesday in May (May 3, 2006)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
This will work. Currently outputs the first Wednesday of the month of the
date entered in cell A1. =DATE(YEAR(A1),MONTH(A1),1+MOD(4-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),7)) -- Regards, Dave "Barbara" wrote: I need to calculate the (for example) first Wednesday of every month, given the date April 5, 2006 is entered in a cell. How do I calculate the new date, the first Wednesday in May (May 3, 2006)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
If you have April 5, 2006 in A1 then in A2 copied down use this formula =A1+35-(DAY(A1+28)<9)*7 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=524476 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |