Populate cell with Week Commencing dates

**lucraft** · 09-07-2011, 07:14 AM

Hi,

I have a sheet that contains lots of data. One column shows the date when a job is completed, however i need to produce a regular report on the completions by week commencing date.

Is there a formula that can add a new cell with the W/C date?

An example workbook is attached.

Thanks
Lucraft

**alansidman** · 09-07-2011, 07:29 AM

deleted -- wrong answer

**Richard Buttrey** · 09-07-2011, 07:32 AM

Hi,

One way

Please Login or Register  to view this content.

Regards

**alansidman** · 09-07-2011, 07:33 AM

Try this:

=IF(WEEKDAY(A4,1)=5,A4,IF(WEEKDAY(A4,1)=6,A4-1,IF(WEEKDAY(A4,1)=7,A4-2,IF(WEEKDAY(A4,1)=1,A4-3,IF(WEEKDAY(A4,1)=2,A4-4,IF(WEEKDAY(A4,1)=3,A4-5,A4-6))))))

Alan

**lucraft** · 09-07-2011, 07:37 AM

Thanks for the quick replies guys.

I forgot to mention that our W/C dates, stupidly start on a Thursday and include weekends, will these still work?

**alansidman** · 09-07-2011, 07:48 AM

They Should. Test for yourself.

Alan

**lucraft** · 09-07-2011, 09:41 AM

Superb, thanks for the help :D

Populate cell with Week Commencing dates

LinkBack

Thread Tools

Rate This Thread

Display

Populate cell with Week Commencing dates

Re: Populate cell with Week Commencing dates

Re: Populate cell with Week Commencing dates

Re: Populate cell with Week Commencing dates

Re: Populate cell with Week Commencing dates

Re: Populate cell with Week Commencing dates

Re: Populate cell with Week Commencing dates

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions