ExcelBanter - WORKDAY formula in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - WORKDAY formula in excel (https://www.excelbanter.com/excel-worksheet-functions/60395-workday-formula-excel.html)

AMHud

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?

Niek Otten

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?

William Horton

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?

All times are GMT +1. The time now is 01:59 AM.