Hi,

I have a excel spreadsheet and on the first column I have my customer #
and on the second column I have TIER 1, 2, 3, 4, and I have their Valid
From and Valid To date on. Because of the system I am using all my
dates are not flowing. Is there a formula which would tell me that
this customer’s date is not flowing and I could just go back in there
and fix it. If someone knows can you please please help me. I would
be more than happy to send out the visual.

Thank you.


+-------------------------------------------------------------------+
|Filename: example.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3623 |
+-------------------------------------------------------------------+

--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=389953

Hello!

If by “Flowing” you mean that the End Year does not match (that’s the
only thing I could see different), placing the formula below into your
Conditional Format (Column B) will high light those dates/rows for you.


=IF(TEXT(A1,"YYYY")<TEXT(B1,"YYYY"),1,0)

Note: In the Conditional Formatting change the back ground color to a
yellow or red.

Hope this helps!

Fable


--
Fable


------------------------------------------------------------------------
Fable's Profile: http://www.excelforum.com/member.php...fo&userid=2185
View this thread: http://www.excelforum.com/showthread...hreadid=389953

Hi Fable,

Thank you so much for the response. This formula is great. This
formula was another thing that I researching for.

But the flow that I wanted to do is as follows.

For example, let say T1 Valid from and T1 Valid to date is from
10/01/2004 to 05/31/2005, T2 Valid from and T2 Valid to date is from
10/01/2004 to 09/30/2007, I want formula which will tell me that T2
Valid from and T2 Valid to has wrong date or give me a return value
which will tell me that this row has wrong date so I could get estimate
# of how many dates I have to fix. I have this example in Row 17.

This is what I mean by flow, if I have T1 Valid to date 05/31/05 then I
want T2 Valid from start date as of 06/01/05 so it will go by order.

Thank you.


--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=389953

Can someone please help me?

Above is all the information that I need.


--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=389953

I want formula which will tell me that T2 Valid from and T2 Valid to has
wrong date or give me a return value which will tell me that this row
has wrong date so I could get estimate # of how many dates I have to
fix.

This is the problem, and probably why you aren't getting a response.

How are you (or we) going to determine what is a "wrong" date? Are
there set rules for what constitutes a "valid" date? Is the "Valid to"
date a set number of years/months/days from the "Valid from" date? If
you can provide a bit more information as to what would make a date
"wrong" or "right" it would prolly hasten your answer/help. :)

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=389953

Thank you for your honest response.

Wrong date meaning would be something overlapping or gap on the dates.
Right date meaning everything smooths, for example, 10/01/2004 to
02/28/2005, 03/01/2005 to 09/30/2007. If you know any formula please
let me know.

Thank you so much again.


--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=389953