Number of Days Between Two Dates Ignoring Years

[sushi514]

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?

 

[etaf]

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 assume this is what you do NOT want, although only 1 IF
=IF(TODAY()>G53,DATEDIF(G5,TODAY(),"YD"),DATEDIF(TODAY(),G53,"YD"))

 

[sushi514]

Thanks, I mentioned two IFs because I have another IF condition outside of the topic mentioned - apologies!

Unfortunately this formula still doesn't work for me in cases where the date hasn't yet arrived, still seemingly the number of days after the date occurs, until it reaches today's date.

E.g. - the date is 5/31/2010 and it's giving me 326 days between that date and today, 4/22/2021. I'm looking for the result just to give 39 days, without looking at the year. But yet I'm wondering if there's some way I can incorporate this into one longer formula, (rather than splitting out the one column with the entire 5/31/2010 date to ignore the year), to just look at the month and day.

 

[Dave Patton]

I left columns C and D since they may be useful.

T202104a.xlsm
	A	B	C	D	E
1	NAME OF PERSON			Current year -->	2021
2	JANE	31-Jul-00	31-Jul-21	100	100
3	ALAN	16-Mar-19	16-Mar-22	328	328
Birthday

Cell Formulas
Range	Formula
E1	E1	=YEAR(TODAY())
C2:C3	C2	=IF(DATE($E$1,MONTH(B2),DAY(B2))<TODAY(),DATE($E$1+1,MONTH(B2),DAY(B2)),DATE($E$1,MONTH(B2),DAY(B2)))
D2:D3	D2	=C2-TODAY()
E2:E3	E2	=IF(DATE($E$1,MONTH(B2),DAY(B2))<TODAY(),DATE($E$1+1,MONTH(B2),DAY(B2)),DATE($E$1,MONTH(B2),DAY(B2)))-TODAY()