| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cells to show dates as the week-ending date of that
If I have a range of dates in column A (i.e., 3 different dates in this
column: 7/1/06, 7/5/06, and 7/9/06), I want to format cells in column B to show the week-ending date (Sunday) for each particular dates from column A. For example, if column A has 6/29/06 date (Friday), column B should show the week-ending date for that week as 7/2/06 (Sunday). Please advise! Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update cells to today date in a list of dates | Excel Worksheet Functions | |||
| Formating cells with date format | Excel Discussion (Misc queries) | |||
| How to format the date in different cells | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Threaded Mode
