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


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
1 Solution
barry houdiniCommented:
regards, barry
Saurabh Singh TeotiaCommented:
Lets say you simply want to compare dates you can this assuming your value is in A1 and B1
Patrick MatthewsCommented:
Dates are really just numbers behind the scenes, so same logic applies:

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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