# Roundingd ate to nearest Monday

1. ## Roundingd ate to nearest Monday

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.

2. ## Re: Roundingd ate to nearest Monday

formula in "B2"
Formula:
`Please Login or Register  to view this content.`

Both format as : [\$-F800]dddd, mmmm dd, yyyy

3. ## Re: Roundingd ate to nearest Monday

There may be more elegant ways, but this will work with the calving date in A1:

=IF(WEEKDAY(A1)=2,A1,IF(AND(WEEKDAY(A1)>1,WEEKDAY(A1)<6),A1-WEEKDAY(A1)+2,A1+(7-WEEKDAY(A1))))

4. ## Re: Roundingd ate to nearest Monday

Or:

=WORKDAY.INTL(A2-4,1,"0111111")

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