# move date to next Monday if date is on a Friday, Saturday or Sunday

1. ## move date to next Monday if date is on a Friday, Saturday or Sunday

Hi there,

I have a list of dates and I need a formula that will return the date of the following Monday, IF the date falls on a Friday, Saturday or Sunday.

Can anyone help?

Thanks

2. ## Re: move date to next Monday if date is on a Friday, Saturday or Sunday

Try this:

=IF(WEEKDAY(A2)=1,A2+1,IF(WEEKDAY(A2)=6,A2+3,IF(WEEKDAY(A2)=7,A2+2,"XX")))

Replace the XX with whatever value you want if it does not meet the criteria.

3. ## Re: move date to next Monday if date is on a Friday, Saturday or Sunday

One more:
``Please Login or Register  to view this content.``

4. ## Re: move date to next Monday if date is on a Friday, Saturday or Sunday

What do you want to return if the date is Monday, Tuesday Wednesday or Thursday? Assuming next day in those cases try using WORKDAY function, e.g.

=WORKDAY(A1,1)

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