Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2012, 10:44 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If formula for subtracting dates Windows 7 64bit If formula for subtracting dates Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I suppose they are text looking like dates, not real dates



perhaps try the following
Code:
=If(C19*1>=Z19*1,1,2)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 10-05-2012, 05:47 AM
gbaker gbaker is offline If formula for subtracting dates Windows 7 32bit If formula for subtracting dates Office 2010 32bit
Competent Performer
If formula for subtracting dates
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default If formula for subtracting dates

Works like a charm, Thanks Pecoflyer, I appreciate the help!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to add dates terricritch Excel Programming 10 11-08-2011 09:51 AM
If formula for subtracting dates Calculating dates Daria11 Word VBA 1 06-08-2011 06:54 PM
If formula for subtracting dates Mail Merge and GMT/UTC Dates dev98 Mail Merge 2 05-06-2011 05:02 AM
If formula for subtracting dates 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 08:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft