# Populate cell with Week Commencing dates

1. ## Populate cell with Week Commencing dates

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

3. ## Re: Populate cell with Week Commencing dates

Hi,

One way

``Please Login or Register  to view this content.``
Regards

4. ## Re: Populate cell with Week Commencing dates

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

5. ## Re: Populate cell with Week Commencing dates

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?

6. ## Re: Populate cell with Week Commencing dates

They Should. Test for yourself.

Alan

7. ## Re: Populate cell with Week Commencing dates

Superb, thanks for the help :D

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1