Creating a serious of dates, where the dates never fall on the weekend

[blackrosepetals9169]

Hi all,

is there a way to work out dates, such that the next date in the serious will be between a Mon -Fri.

For example, if my start date is 01/01/2018 and I want to work out what the date will be every 28 days, I know I can do =(cell) + 28.

But, I need the return value to be on Monday - Friday.

I tried using the Workday function but this gave me a date that was a week after.

I just need it to work so that if the return date was on a Sat/ Sun it gives me Mondays date if that makes sense?

[Glenn Kennedy]

Try this, with date in A2:

=IF(WEEKDAY(A2+27)=7,A2+27+2,IF(WEEKDAY(A2+27)=1,A2+27+1,A2+27))

if not, plost an excel sheet showig your EXPECTED result for a FEW examples.

[blackrosepetals9169]

Thank you for this, I'll give this a try !

[Glenn Kennedy]

OK. Let us know if it worked out correctly...

---

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

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.