I've been trying to figure out this formula out for weeks but I can't find a solution in the forums that cover what I need!
I need to count the number of blank cells in B1:B170 if the date in A1:A170 is +/- 3 weeks from today(). I need to count the number of cells that are empty only if there is a date listed in Column A as new rows will be added by a few different users on a daily bases. In a dream world, the cells which meet this criteria would be highlighted (I assume this would be easy to accomplish using conditional formatting once the right cells are identified?)
(I'm tracking pregnant women who enroll in a program and need to have a quick way of seeing how many patients are full term (+/- 3 weeks from due date) and have yet to deliver. As patients enroll, I will add their expected due date in Column A, and will update Column B when they deliver.)
Hope that is clear enough. Please let me know if you need any clarification or would like a sample set of data. I'd say my excel wrangling skills are moderately intermediate but I am totally stuck here.
Bookmarks