| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using a col of Dates by day I want to determine a wk ending date.
Using a column of Dates by day I want to determine a wk ending date (sat
date) for each date, based on comparing that date to a range of dates that are Sun thru Sat. |
|
#2
|
|||
|
|||
|
Hi,
Say a date is in A1, to get the next Saturday use the formula: =A1+7-WEEKDAY(A1) Regards, Sebastienm "Ken Espo" wrote: Using a column of Dates by day I want to determine a wk ending date (sat date) for each date, based on comparing that date to a range of dates that are Sun thru Sat. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range of dates determine days | Excel Worksheet Functions | |||
| Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Lookup a date between other dates | Excel Worksheet Functions | |||
| Lookup a date between other dates | Excel Worksheet Functions | |||
Linear Mode
