Count Days Building Up To TODAY()

[ExcelRoy]

Hi All,

I am trying to count the days building up to TODAY() but the DATEDIF doesn't seem to count before the TODAY() date

Any ideas how to show in days a date prior to TODAY()

THanks

 

[steve the fish]

The earliest date just needs to be first in the DATEDIF formula. That said if you are counting days just do a subtraction: largest date - smallest date