K
Ken G
I have a list of dates in the format dd/mm/yyyy and I want
to count the number of dates older than 7 days. I'm trying
to use the "countif" function =countif(F7:F80"<today()-7")
and if that worked I wouldn't be asking for help. No matter
what combinations I try, it always gives a value of zero. I
thought that Excel stored dates in the format of a number
starting at 1 jan 1900 so I can't see why it won't work. If
I take out the minus 7 it still gives a result of zero.
to count the number of dates older than 7 days. I'm trying
to use the "countif" function =countif(F7:F80"<today()-7")
and if that worked I wouldn't be asking for help. No matter
what combinations I try, it always gives a value of zero. I
thought that Excel stored dates in the format of a number
starting at 1 jan 1900 so I can't see why it won't work. If
I take out the minus 7 it still gives a result of zero.