# Rounding dates to specific working days of the week

1. ## Rounding dates to specific working days of the week

Hi - I need to round order dates to dates in the future based on a fixed delivery schedule, for example:

Order 1 Created 13/07/2016 - round to the next Tues
Order 2 Created 13/07/2016 - round to the next Weds
Order 3 Created 14/07/2016 - round to the next Mon etc etc

Can anyone advise a solution for this?

Many thanks

2. ## Re: Rounding dates to specific working days of the week

Originally Posted by Sarah C
Hi - I need to round order dates to dates in the future based on a fixed delivery schedule, for example:

Order 1 Created 13/07/2016 - round to the next Tues
Order 2 Created 13/07/2016 - round to the next Weds
Order 3 Created 14/07/2016 - round to the next Mon etc etc
etc etc? How are you actually determining which is the next date to 'round' up to?

3. ## Re: Rounding dates to specific working days of the week

Originally Posted by Sarah C

Order 1 Created 13/07/2016 - round to the next Tues
Order 2 Created 13/07/2016 - round to the next Weds
Both have the same date yet one gets rounded to Tues while the other gets rounded to Wed.

What is the logic behind this?

I predict this is going to be a nightmare!

4. ## Re: Rounding dates to specific working days of the week

Hey - thanks for the quick response! The delivery dates (so the round up to dates) are all pre-determined at customer level so this will be a fixed field per order.
We could therefore have different orders (which will be for different customers) that will need to round to different dates.

So:

Customer 1 takes delivery Tuesday, order created Monday, round up date to the next Tuesday
Customer 2 takes delivery Weds, order created Sunday, round up date to the next Weds
Customer 3 takes delivery Tuesday, order created Thursday, round up date to the next Tuesday

Hence the etc in the original post, there could be a number of different combinations. I have the weekday numbers for both the order creation date and the customer delivery day but need to calculate the round up date.

Thanks for all your help!!

5. ## Re: Rounding dates to specific working days of the week

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

6. ## Re: Rounding dates to specific working days of the week

Actually, try this:
Formula:
`Please Login or Register  to view this content.`

Where myOrderDate and myDeliveryWeekday are cell references...

7. ## Re: Rounding dates to specific working days of the week

Perfect! Thanks so much for your help, very much appreciated!

8. ## Re: Rounding dates to specific working days of the week

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

##### Users Browsing this Thread

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