Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto calculate day of week to week of the year (not as serial)
Here's what I'm looking to do:
Today is 23 June 2008. Based on a SUN-SAT week, 23 June 2008 is the week of 28 June 2008. (I want to return the actual date, not the week's serial number.) How can I set this up so it calculates this automatically? Much thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto calculate day of week to week of the year (not as serial)
If your date is in A1, use this:
=A1+7-WEEKDAY(A1) Hope this helps. Pete On Jun 23, 3:48*pm, oftenconfused wrote: Here's what I'm looking to do: Today is 23 June 2008. Based on a SUN-SAT week, 23 June 2008 is the week of 28 June 2008. * (I want to return the actual date, not the week's serial number.) *How can I set this up so it calculates this automatically? Much thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto calculate day of week to week of the year (not as serial)
=A1+7-WEEKDAY(A1)
-- David Biddulph "oftenconfused" wrote in message ... Here's what I'm looking to do: Today is 23 June 2008. Based on a SUN-SAT week, 23 June 2008 is the week of 28 June 2008. (I want to return the actual date, not the week's serial number.) How can I set this up so it calculates this automatically? Much thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto calculate day of week to week of the year (not as serial)
Thanks!
"Pete_UK" wrote: If your date is in A1, use this: =A1+7-WEEKDAY(A1) Hope this helps. Pete On Jun 23, 3:48 pm, oftenconfused wrote: Here's what I'm looking to do: Today is 23 June 2008. Based on a SUN-SAT week, 23 June 2008 is the week of 28 June 2008. (I want to return the actual date, not the week's serial number.) How can I set this up so it calculates this automatically? Much thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto calculate day of week to week of the year (not as serial)
You're welcome - thanks for taking the trouble to feed back.
Pete On Jun 23, 5:06*pm, oftenconfused wrote: Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
Sort by week and year | Excel Worksheet Functions | |||
Sort by Year and Week | Excel Worksheet Functions | |||
Week of the Year | Excel Discussion (Misc queries) | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) |