I get the formula to run okay, but I keep getting the year 1900...how do I
get 2005 or future years to appear?
I get the formula to run okay, but I keep getting the year 1900...how do I
get 2005 or future years to appear?
What's your formula? What are the values of the input cells?
--
Kind regards,
Niek Otten
"AMHud" <[email protected]> wrote in message
news:[email protected]...
>I get the formula to run okay, but I keep getting the year 1900...how do I
> get 2005 or future years to appear?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks