Hi,
I am trouble getting the right results using the IF function with dates. I would like the If function to compare 2 dates (some in different years) and if one date 5/30/2011 is before the second date 3/31/2012 then yes value should be zero and if it is not then I would like it to calculate an amount. But the outcome is always showing the calculation and never a zero regardless of dates.
Can you please help,
Thank You,
I am attaching a sample of what I am trying to do.
=IF(D6<J3,0,F6*J4/36*3)
Bookmarks