If formula for subtracting dates

		Microsoft Office Forums > Microsoft Excel > Excel
If formula for subtracting dates

FAQ

Thread Tools

Display Modes

10-04-2012, 10:39 AM

gbaker

Windows 7 32bit If formula for subtracting dates

Office 2010 32bit

Competent Performer

Join Date: May 2012

Posts: 111

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code to add dates	terricritch	Excel Programming	10	11-08-2011 09:51 AM
Calculating dates	Daria11	Word VBA	1	06-08-2011 06:54 PM
Mail Merge and GMT/UTC Dates	dev98	Mail Merge	2	05-06-2011 05:02 AM
Calculated dates.	Ziggy-R	Word	10	09-28-2010 01:42 AM
Adding dates	mkkram	Word	0	11-27-2006 09:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:53 AM.