| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week ending calculation
I am working in a sheet where I have a date and I am trying to find the
Friday post date. I am using =DATE(YEAR(E2),MONTH(E2),DAY(E2)-WEEKDAY(E2)+6) It works for everyday unless the day is a Saturday. I've tried several other formulas (found on the discussion board) and get basically the same results. Michelle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| week ending funciton | Excel Worksheet Functions | |||
| week ending | Excel Worksheet Functions | |||
| Week Ending formula | Excel Discussion (Misc queries) | |||
| Week ending | Excel Worksheet Functions | |||
Threaded Mode
