UPDATE - My initial question has been answered. Follow up question at the bottom.
I'm trying to find the days, months, weeks, years between two dates (today and list of birthdays).
I couldn't find the weeks using DATEDIF so I found an easier solution and used:
=ABS(TODAY()-J2) for Days
=ABS(TODAY()-J2)/7 for Weeks =ABS(TODAY()-J2)/(365/12) for Months
You'll see that for months (K) it gives me a decimal of 1.18356 but I want it to say 1 month and 6 days. I'm not sure if you can do this in one cell so you can see I created a column (L) next to weeks hoping I could come up with a formula for it to show 6 days. The same thing happens for Weeks (M). Does anyone know how to convert this? Thank you in advance for your help.
I'm a beginner with this so I don't have many tools to pull from. I honestly don't know where to start with this.
With the help of Gilbert I used the MOD function to use with my first question. I'm trying to perform the same calculation between the birth date and today but I'm still getting those decimals. enter image description here
Is there another function I could use?