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
 

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

How to enter start and end date/time in excel based on some specific value. 7
Date problem 2
Week ending date query help 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Making one cell in another row equal another all the time 4
How to refer to active cell on spreadsheet? 1
Number of hrs worked in a week, based on dates in a different column 1
How to put an Empty Cell in an IF function... 3

Top