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
