Date of Sunday In Excel

I'm looking to return the date of Sunday in the week.  What I mean by this is if I input the date 8/8/07, I would like the funtion to return 8/5/07.  I just want the Excel cell  to return what date Sunday is during the week that I input from a different cell.  I'm not sure at all how to do this; any assistance is appreciated.

Thanks!
LVL 1
jjrr007Asked:
Who is Participating?
 
Rory ArchibaldCommented:
or slightly shorter:
=A1-WEEKDAY(A1,2)
Regards,
Rory
0
 
Rory ArchibaldCommented:
Try:
=A1-WEEKDAY(A1,1)+1
where A1 contains your date.
HTH
Rory
0
 
Rory ArchibaldCommented:
Thanks for the grade.
Rory
0
 
byundtCommented:
jjrr007,
Although both of Rory's formulas work on Monday through Saturday--his second one may leave you feeling like Melina Mercouri in Never on Sunday. By that, I mean that if A1 is a Sunday, the second formula returns the Sunday from the previous week--while the first formula returns the same date.

Brad
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.