R
Roy M. Lee
I am getting an error when using "Days360" to calculate days worked
(including weekends) in Excel 2003 on XP and also in Excel 2007 on Vista
between the months of July and August 2008.
The formula in the cell: "=IF(F14="","",DAYS360(F12,F14+1)*100)" (The "+1"
is to calculate each day worked and the "times 100" is a dollar amount for
each day).
If I enter July 23 2008 as the beginning and July 30 as the ending I get
800. If I enter July 23 2008 as the beginning and July 31 as the ending I
STILL get 800. (Or any date after July 31 for that matter.)
If I remove the "+1" from the formula, entering July 31 and August 1 show
the same value.
Is this a known bug? Is there a fix for it yet?
(including weekends) in Excel 2003 on XP and also in Excel 2007 on Vista
between the months of July and August 2008.
The formula in the cell: "=IF(F14="","",DAYS360(F12,F14+1)*100)" (The "+1"
is to calculate each day worked and the "times 100" is a dollar amount for
each day).
If I enter July 23 2008 as the beginning and July 30 as the ending I get
800. If I enter July 23 2008 as the beginning and July 31 as the ending I
STILL get 800. (Or any date after July 31 for that matter.)
If I remove the "+1" from the formula, entering July 31 and August 1 show
the same value.
Is this a known bug? Is there a fix for it yet?