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
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
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.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
One more:
Please Login or Register to view this content.
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)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks