| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WORKDAY formula in excel
I get the formula to run okay, but I keep getting the year 1900...how do I
get 2005 or future years to appear? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY formula in excel
What's your formula? What are the values of the input cells?
-- Kind regards, Niek Otten "AMHud" wrote in message ... I get the formula to run okay, but I keep getting the year 1900...how do I get 2005 or future years to appear? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WORKDAY formula in excel
The formula
=WORKDAY(A1,A2,) Produces the result 1/7/2005 for me when cell A1 has 1/1/2005 in it and cell A2 has 5 in it. Perhaps you need to check the way the cells are formatted. Mine are formatted as dates (except A2 with the 5 which is formatted general). Hope this helps. Thanks, Bill Horton "AMHud" wrote: I get the formula to run okay, but I keep getting the year 1900...how do I get 2005 or future years to appear? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
