| 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) | |||
Linear Mode
