Hi,
I'm trying to create a dynamic formula that works off of today's date, where I am trying to calculate the number of days between today, and a column of dates that can vary.
E.g. =DATEDIF(G53,TODAY(),"YD") where dates in Column G represents someone's start date with the company, so (5/1/2000, 9/23/2016, 2/1/1990, etc.) - dates vary across the board.
My issue of course is that the formula calculates correctly if the reference date in Column G has already passed today's date (ignoring the year). But does not calculate correctly if the date (ignoring the year) has yet to arrive.
Does anyone have any ideas as to how I can update my DATEDIF formula to account for this, outside of me needing to create two different IF formulas depending on if the month/day in Column G is greater or less than today's current date?
I'm trying to create a dynamic formula that works off of today's date, where I am trying to calculate the number of days between today, and a column of dates that can vary.
E.g. =DATEDIF(G53,TODAY(),"YD") where dates in Column G represents someone's start date with the company, so (5/1/2000, 9/23/2016, 2/1/1990, etc.) - dates vary across the board.
My issue of course is that the formula calculates correctly if the reference date in Column G has already passed today's date (ignoring the year). But does not calculate correctly if the date (ignoring the year) has yet to arrive.
Does anyone have any ideas as to how I can update my DATEDIF formula to account for this, outside of me needing to create two different IF formulas depending on if the month/day in Column G is greater or less than today's current date?