I'm trying to round a date that an animal calves to the nearest Monday. Therefore in say cell A2 I will have the calving date and I want cell B2 to show the nearest Monday to that date. It may be the previous Monday if animal calves on a Tuesday, Wednesday of Thursday. Or the following Monday if animal calves on a Friday, Saturday or Sunday. If animal calves on a Monday then that date will be the same in B2. Hope that makes sense and any help would be appreciated.
Bookmarks