Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I followed examples to display all dates in a given week as "Week 26"
or "Week 31" but would like to modify the date so it reads "Week of July 29, 2007." the formula I'm using looks like this: =TRUNC(((A7-DATE(YEAR(A7),1,1))/7))+1+IF(WEEKDAY(DATE(YEAR(A7), 1,1))WEEKDAY(A7),1,0) thanks for any help! I would like to stick to something easier rather than more complex if such a solution exists. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - no "week" period available for chart formatting | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
"As of" & "July 31, 2005" | Excel Programming |