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

**ea223** · 08-24-2014, 12:02 PM

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

**alansidman** · 08-24-2014, 12:18 PM

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.

**Armando Montes** · 08-24-2014, 01:52 PM

One more:

Please Login or Register  to view this content.

**daddylonglegs** · 08-24-2014, 01:54 PM

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)