| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the next dayof the week after a certain date.
Is there a way to return the date of a particular day after a date, i.e. my
work month always starts on the 26th, but the week ends on sunday. I would like to enter the first day of the month (the 26th), and automaticaly generate the week start and end dates (mon-sun). I need a formula to return the date for the first sunday after the 26th. ex: week 1 - 6/26/08(thu) - 6/29/08(sun) week 2 - 6/30/08(mon) - 7/6/08(sun) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the date using the number of the week in a year | Excel Worksheet Functions | |||
| Finding Friday in week number | New Users to Excel | |||
| Finding day of week in 2030 | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Threaded Mode
