EXCEL - Calculate Date Differences and place an X in the Column

[jellybead]

Hi,

I need to calculate the difference between a Delivery Date and an Actual Ship date.

The results needs to be an X if the Actual Ship date is "earlier" than the Delivery Date.

In another column, I need to show an X if the Actual Ship date is "later" than the Delivery Date.

I need a formula to make this happen.

Would one of you kind Excel guru's help me out?

Thanks in advance

 

[SkipVought]

Hi,

[tt]
=if(Actual_Ship_date<Delivery_Date,"X","")
[/tt]
Use this formula in the column you want the X in. I have used Range Names in lieu of cell references.

Skip,

[red]Be advised:[/red] Alcohol and Calculus do not mix!
If you drink, don't derive!

Want to get great answers to your Tek-Tips questions? Have a look at FAQ222-2244

 

[jellybead]

Thank you so much! I works very well.