| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday function linked in an argument of If formula.
In A1 a separate sheet will feed in the number of days. (from "no data", or 0
to 31) in A2 : = if(A1="no data","x",A1) in B1 a separate sheet will feed in a date. in B2 : = WORKDAY(B1,A2) this B2 is used as the end date of a WORKDAY scheduling. I happen to run the schedule and have not detected the invalid workday result of B2. This happens when A1 = 0 A2 = 0 B1 = a date that falls on sunday or saturday. B2 = a date that is printed as a sunday or saturday. Workday function do not govern the needed result. do anybody encounter this scenario. Or maybe i am just confused happy holidays hohoho dribler2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I put Goal Seek into a cell formula? | Excel Worksheet Functions | |||
| extract matching vales | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| IF Function to test formula in a cell | Excel Worksheet Functions | |||
Threaded Mode
