Formula that counts difference in days between two dates.

Originally Posted by elmaco12

Hi!

I have a column (F) full of dates. I want to create a column (L) that contains the number of days, that differentiate col.F and todays date.

is this possible?

DateDif should work for you
=DATEDIF(F1,TODAY(),"D")

More on datedif here
http://office.microsoft.com/en-us/he...609811033.aspx