Enter date in one cell, and the week ending date [Sunday] appears inthe "W/E" cell

T

Tonso

I have an XL 2003 workbook that I enter the date an event occured in
cell C7. I want to make another cell [C2]display the week ending date
[Sunday], based ono the date entered in cell C7. How can I accomplish
this?

Thanks,

Tonso
 
R

Ron Rosenfeld

I have an XL 2003 workbook that I enter the date an event occured in
cell C7. I want to make another cell [C2]display the week ending date
[Sunday], based ono the date entered in cell C7. How can I accomplish
this?

Thanks,

Tonso
Click to expand...

=C7+7-WEEKDAY(C7-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validate cell for date, as well as day of the week 3
Preventing data input until a particular cell is used 3
Populating the last Sun. date of that week in a cell 4
Making one cell in another row equal another all the time 4
Week ending date query help 1
Show value from one cell in another cell if today falls between a date range 5
Date problem 2
If cell is blank automatically enter today's date in the same cell 21

Top