I have an effort tracking sheet which has column for each day. I have defined range name for each column. I need to show how amy cells has 'NA' in it for a specific range name. it should take todays date range automatically and show NA count for that perticular range. Is it possible?