Auto calculate day of week to week of the year (not as serial)

's Computer Specifications

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!

's Computer Specifications

If your date is in A1, use this:

=A1+7-WEEKDAY(A1)

Hope this helps.

Pete

On Jun 23, 3:48*pm, oftenconfused
<oftenconfu...@discussions.microsoft.com> 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!

's Computer Specifications

=A1+7-WEEKDAY(A1)
--
David Biddulph

"oftenconfused" <(E-Mail Removed)> wrote in message
news:FD7DF7C0-734E-4820-B887-(E-Mail Removed)...
> 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!
>

's Computer Specifications

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
> <oftenconfu...@discussions.microsoft.com> 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!
>
>

's Computer Specifications

You're welcome - thanks for taking the trouble to feed back.

Pete

On Jun 23, 5:06*pm, oftenconfused
<oftenconfu...@discussions.microsoft.com> wrote:
> Thanks!
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate Week of Year	PatK	Microsoft Access VBA Modules	7	7th Jan 2008 11:33 PM
Calculate a date knowing the week number and year	=?Utf-8?B?U2FyYWg=?=	Microsoft Access Form Coding	7	2nd Aug 2006 06:07 PM
How do i calculate fiscal week of the year	evlai@hotmail.com	Microsoft Excel Discussion	4	22nd Sep 2005 02:04 PM
Finding a date from year, week of the year (1-52) and day of the week (1-7)	Loucas	Microsoft Excel Worksheet Functions	7	28th Jan 2004 04:21 PM
How do you calculate the week number in a year of a given date?	Mike	Microsoft Access Forms	2	21st Nov 2003 12:24 PM