| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Date
I am trying to create a formula that will take a specific date in a cell and
give the date 35 days prior. I am only concerned with Mon-Fri. So, if the date falls on a Saturday then give the Friday date. If the date falls on a Sunday, then give the Monday date. I am not sure where to begin. I wrote the following function of "= A2 - 32" Any help is greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a date, 10 weeks after a set date & return a specific da | Excel Worksheet Functions | |||
| Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Threaded Mode
