Formula to produce Sunday date

[scaffdog845]

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!

[Ron Coderre]

With
A1: a date

This regular formula returns the Sunday date of the week containing the A1 date

Please Login or Register  to view this content.

Does that help?

[scaffdog845]

[QUOTEDoes that help?[/QUOTE]

Yep! Thanks Ron.... Have a good one!