# Putting dates into week commencing

1. ## Putting dates into week commencing

Afternoon all,

Anyone know how I can convert the attached to firstly read as a normal date, then convert into week commencing?

Many thanks,

RL

2. ## Re: Putting dates into week commencing

To convert, in B2 dragged down (first format column B as Date)

=MID(A2,5,2)&"/"&RIGHT(A2,2)&"/"&LEFT(A2,4)+0
then you can copy and paste special > values back into A

I'm not sure what you want by "week commencing" probably a language issue across the pond here.

3. ## Re: Putting dates into week commencing

To convert select the range - Data - Text to columns - Next - Next - Select Date in Column Data format - Select YMD from ddown - Ok

I don't understand the rest of your requirment

4. ## Re: Putting dates into week commencing

What is needed now is to include this in the formula. What is being requested is the first day of the week in which the given dates fall. So, for instance if it is Monday then applying this to the date should work.

=A2-WEEKDAY(A2,1)+3

That's if the date is in A2

5. ## Re: Putting dates into week commencing

In B2 put

=MID(A2,7,2)&"/"&MID(A2,5,2)&"/"&MID(A2,1,4)

In C2 put

=B2-WEEKDAY(B2,1)+3

Edit - Format as date

6. ## Re: Putting dates into week commencing

Thanks all but especially to Russell. Perfect.

RL

7. ## Re: Putting dates into week commencing

You're welcome. I was hoping to be able to combine the formulae but if you can live with it as it is (maybe hide a column) then so be it.

Cheers from just down the road!

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