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

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
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:

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

OzGrid Business Applications