MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I create a formula to show a variance between 2 dates??


Posted by Tracy on February 08, 2001 11:03 AM

I need to create a chart that shows the variances between 2 dates. The third column should be in red for the total of days late.


Posted by Gregc on February 08, 2001 11:25 AM

response:
=IF(B9-A9<0,B9-A9,"")
a9 and b9 are the dates and the formula goes in the cell you want the overdue number in.

Posted by Rick M on February 08, 2001 12:04 PM

You can also use formula
=B1-A1
Then format column C to a number

Posted by DaVe Hawley on February 08, 2001 5:17 PM


Hi Tracy

The DATEDIF formula combined with MIN and MAX is handy for this. Supposing you two dates are in cells A1 and B1 put this in C1:
=DATEDIF(MIN(A1:B1),MAX(A1:B1),"d")

It can also take "m","Y" etc

To tun the result Red should it exceed a certain number of days take a look at Conditonal Formatting under "Format" on the toolbar.

Hope this helps
Dave

OzGrid Business Applications