| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract 2 days and if it falls on Sat or Sun display Friday.
=WORKDAY(A1,-3)
"ScottG" wrote: Date substraction - A1 has 4/2/2008 and I want to subtract three days. Therefore, the answer is 3/30/2008 (Sunday) then I want to fall back to Friday 3/28/2008. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract 3 days from Date with a Twist Q | Excel Worksheet Functions | |||
| How to subtract 2 dates to get number of days.....please | Excel Worksheet Functions | |||
| set payment date 28 days after following friday | Excel Discussion (Misc queries) | |||
| Add or Subtract Working Days in Excel | Excel Discussion (Misc queries) | |||
| Subtract number of Working Days | Excel Worksheet Functions | |||
Threaded Mode
