Excel 2010 IF stmt based on DATE value

June 27, 2011 at 08:25:04
Specs: Windows XP
Excel 2010 IF stmt based on DATE value: I have a simple employee expense report that calculates mileage in cell D12 based on the date in cell B12.

My formulas is as follows: =IF($B12>=DATE(2011,1,7),$D12*0.555,$D12*0.51).

All mileage incurred equal to or greater than 07/01/11 should be calculated at $0.555 cents while all else should be calculated at $0.51 cents. I believe it's as simple as Excel not recognizing my DATE(2011,1,7), as the date 07/01/11... Help?

See More: Excel 2010 IF stmt based on DATE value

Report •

June 27, 2011 at 08:52:06
You are right, Excel will not recognize DATE(2011,1,7) as 07/01/2011 since
DATE(2011,1,7) means January 1, not July 7.

The syntax is: DATE(year,month,day)

=DATE(2011,1,7)=DATEVALUE("1/7/2011") will return TRUE.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question