Hey all,
I'm try to figure out a formula that will calculate Sunday's date of a given week based on a Monday-Sunday date in a different cell.
EX. A1 - 5/12/11 result in A2 - 5/15/11
A1 - 5/15/11 result in A2 - 5/15/11
Any ideas?
Thanks Gang!
Hey all,
I'm try to figure out a formula that will calculate Sunday's date of a given week based on a Monday-Sunday date in a different cell.
EX. A1 - 5/12/11 result in A2 - 5/15/11
A1 - 5/15/11 result in A2 - 5/15/11
Any ideas?
Thanks Gang!
Last edited by scaffdog845; 05-12-2011 at 02:22 PM.
Click here to read the Forum Rules
Whatever it is in life you decide to go after, go after with great ferocity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks