| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Workday syntax
I used the Excel Help example to build the following:
Days Needed Date Description (Result) 11/3/2004 15 WORKDAY(C4,A5) 25 WORKDAY(C4,A6) 40 WORKDAY(C4,A7) 45 WORKDAY(C4,A8) 125 WORKDAY(C4,A9) 145 WORKDAY(C4,A10) I don't get the "result" in the final column as shown in Help. Cells that contain date and Description/result are formatted for date (mmddyyyy). Days needed cells are formatted for number. Workday cells formatted general, cells locations are correct. Add-ins are accessible. Any suggestions? |
|
#2
|
|||
|
|||
|
Hi Paula
seems to work fine for me, what exactly are the results you are getting for each line? Cheers JulieD "PaulaC" wrote in message ... I used the Excel Help example to build the following: Days Needed Date Description (Result) 11/3/2004 15 WORKDAY(C4,A5) 25 WORKDAY(C4,A6) 40 WORKDAY(C4,A7) 45 WORKDAY(C4,A8) 125 WORKDAY(C4,A9) 145 WORKDAY(C4,A10) I don't get the "result" in the final column as shown in Help. Cells that contain date and Description/result are formatted for date (mmddyyyy). Days needed cells are formatted for number. Workday cells formatted general, cells locations are correct. Add-ins are accessible. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax to check protected status of a worksheet? | Excel Discussion (Misc queries) | |||
| I need the syntax for the cube root function in excel. | Excel Discussion (Misc queries) | |||
| Vlookup Syntax Error | New Users to Excel | |||
| when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
| How do I get the WORKDAY function? | Excel Discussion (Misc queries) | |||
Linear Mode
