2008-10-01 and 2009-09-30
I've tried almost all Date formats provided by MS, also General and
Number
no avail
On 22 Mar, 21:28, "T. Valko" wrote:
What dates do you have in A1 and A2?
--
Biff
Microsoft Excel MVP
"Jarek Kujawa" wrote in message
...
it looks fine to me too
but despite everything is set OK with the dates in my worksheet the
result still comes wrong
thks for yr response
On 22 Mar, 12:56, Bernd P wrote:
Hello Jarek,
The formula looks fine, maye you got an input date wrong - perhaps got
tricked by Excel "auto century guess" 1900 resp. 2000?
But if you want to count single weekdays there is a better non-
volatile formula:http://www.sulprobil.com/html/date_formulas.html
Regards,
Bernd- Ukryj cytowany tekst -
- Pokaż cytowany tekst -