Solved

Excel

Posted on 2009-05-19
3
172 Views
Last Modified: 2012-05-07
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
Comment
Question by:weklica
3 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 24424650
Try
=(B1-A1>=180)+0
regards, barry
0
 
LVL 59

Expert Comment

by:Saurabh Singh Teotia
ID: 24424657
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
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 250 total points
ID: 24424665
Dates are really just numbers behind the scenes, so same logic applies:

=IF((A2-B2)>=180,1,0)
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question