Dynamic formulas
I am currently trying to get a cell to recognize the amount of work completed
by employees on a certain day, automatically. Each employee uses a monthly
log, and column A includes the day in M/DD format, whereas column G includes
the word "Completed" or "Deferred." I have worked out the formula to get a
different tab to count up "Completed" in a range of column G, but as the
sheet is monthly I am unable to get it to count up the amount for a specific
day, so they may manage their productivity.
How would I be able to get Excel to recognize today's date, and count up the
amount completed in column G just for that date?
|