Solved

# Date of Sunday In Excel

Posted on 2007-08-09
1,747 Views
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
Question by:jjrr007

LVL 85

Expert Comment

Try:
=A1-WEEKDAY(A1,1)+1
HTH
Rory
0

LVL 85

Accepted Solution

or slightly shorter:
=A1-WEEKDAY(A1,2)
Regards,
Rory
0

LVL 85

Expert Comment

Rory
0

LVL 80

Expert Comment

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.

0

## Featured Post

### Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…