View Single Post
 
Old 10-04-2012, 10:39 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default 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.
Reply With Quote