• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

Excel

I have column A and Column B.  Both have dates.  If column A is bigger than column B, I can have column C indicate so by =if(A:1>B:1,1,0).  How do I get 1's and 0's dispersed through column C if Column A is 180 days older than Column B?  So, same theory as greather than less than, but with dates.  Thanks
0
weklica
Asked:
weklica
1 Solution
 
barry houdiniCommented:
Try
=(B1-A1>=180)+0
regards, barry
0
 
Saurabh Singh TeotiaCommented:
Lets say you simply want to compare dates you can this assuming your value is in A1 and B1
=IF(AND(B1>180,A1>B1),1,0)
Saurabh...
0
 
Patrick MatthewsCommented:
Dates are really just numbers behind the scenes, so same logic applies:

=IF((A2-B2)>=180,1,0)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now