Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1810
  • Last Modified:

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!
0
jjrr007
Asked:
jjrr007
  • 3
1 Solution
 
Rory ArchibaldCommented:
Try:
=A1-WEEKDAY(A1,1)+1
where A1 contains your date.
HTH
Rory
0
 
Rory ArchibaldCommented:
or slightly shorter:
=A1-WEEKDAY(A1,2)
Regards,
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

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now