If formula for subtracting dates
I am trying to make this formula work.
9/11/12= c19
If(C19>=Z19,1,2)
01/18/12
=z19
C19 is more than Z19 so I should get a 1 but I get a 2.
Does it have something to do with the fact that these are dates. If so any suggestions to make it work.
|