Change Saturday or Sunday to Monday by date

[pfulghum]

=IF(WEEKDAY(A2)="","",LOOKUP(WEEKDAY(A2),{1,2,3,4,5,6,7},{7,2,5,4,3,2,1}))

I would like to look at A2, if the result of the weekday formula is a 7 then i would like it to take A2 + 2 and return 4/4/16. Obviously I would like if A3 was 4/3/16 i would like to return 4/4/16, if A4 is 4/4/16 i would like it to return 4/4/16, etc....

[zbor]

Perhaps this:

Please Login or Register  to view this content.

[Phuocam]

Try this formula:
=IF(A2="","",A2+7-WEEKDAY(A2,12))

[samba_ravi]

B2

Please Login or Register  to view this content.

Try this and copy towards down

[pfulghum]

Thank you both

[pfulghum]

How do i mark this as solved?

[zbor]

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