| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract 3 days from Date with a Twist Q
How could I expess a formula that will show -3 days from a certain
date, but if the answer is a weekend date then it must return the previous friday Example: Cell A2= 15/11/07, I must return -3 days from this is A1, but this = 11/11/07 which is a weekend date, thus I require an answer of 09/11/07 i.e. a Friday Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract/add a known number of days/months from a date? | Excel Worksheet Functions | |||
| How to subtract 2 dates to get number of days.....please | Excel Worksheet Functions | |||
| Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
| Add or Subtract Working Days in Excel | Excel Discussion (Misc queries) | |||
| excel formula that can subtract days | Excel Worksheet Functions | |||
Threaded Mode
