Hi.
i have a spreadsheet where within a range of cells i insert dates on a daily basis
i would like a formula which calculates the percentage of cells containing a date out of the range i specify.
i got this from another topic and can change the range to fit my needs and works when i type in "h" but i am unsure how to replace the "h" in the formula so it loks for a date instead..=countif(b10:f19,"h")/counta(b10:f19)
EDIT..
i have got this far on my own, now i can get a count on the cells with a date inserted from todays date back, but still cant convert it to be a percentage of my range....
=COUNTIFS(A1:A8,"<"&TODAY()+1/COUNTIFS(A1:A8,"<"&TODAY()))
Bookmarks