Which Excel formula can be used to automatically count the number of days from a given date to today?
A) =DATEDIF(A1, TODAY(), "d")
B) =DATE(A1) - TODAY()
C) =COUNTIF(A1, TODAY())
D) =TODAY() - DATE(A1)