Great video Adam, I look forward to going through this content! I found that since the Days360 function assumes a 360 day calendar year, I had to divide by 360 instead of 365.25 to obtain the correct age value from the DOB.
Yeah, you're spot on. Thanks so much for bringing this to my attention! For whatever reason, at the time I was doing the calculation I was thinking the function was DAYS365. I wish I could somehow upvote this comment so that everyone sees it! An alternative solution is to use: =DATEDIF(D2,TODAY(),"D")/365.25) An alternative solution in specific reference to this tutorial video: =IF(D2="","",DATEDIF(D2,TODAY(),"D")/365.25) --> I use 365.25 to accommodate for leap years, but even with this adjustment, the age is very slightly off (slightly more accurate than using 365).
@@AdamVirgile34 I used the DAYS function and it works great without all the complications of division and all that and went like this: =If(F2="","",If(A2="","", DAYS(Today(),F2)/365.25)) Amazing video. Thank you for sharing
That's a great question, Eric. You have to do each one individually. Here's what I do: - I get URL links for the images I need - I use =IMAGE() to get the image for that URL If you don't get the URL images, you will need to re-insert all images into new Workbooks. This isn't an answer to your question, but I thought you would like to know how I do things to mitigate manual labor if dealing with multiple workbooks. I have one workbook that is "Profiles." In this workbook, I store all image URLs with other important profile information. I then use IMPORTRANGE to pull the "Profiles" into other workbooks that have databases and visualizations. I hope this helps!
Great video Adam, I look forward to going through this content! I found that since the Days360 function assumes a 360 day calendar year, I had to divide by 360 instead of 365.25 to obtain the correct age value from the DOB.
Yeah, you're spot on. Thanks so much for bringing this to my attention! For whatever reason, at the time I was doing the calculation I was thinking the function was DAYS365. I wish I could somehow upvote this comment so that everyone sees it!
An alternative solution is to use:
=DATEDIF(D2,TODAY(),"D")/365.25)
An alternative solution in specific reference to this tutorial video:
=IF(D2="","",DATEDIF(D2,TODAY(),"D")/365.25)
--> I use 365.25 to accommodate for leap years, but even with this adjustment, the age is very slightly off (slightly more accurate than using 365).
@@AdamVirgile34 I used the DAYS function and it works great without all the complications of division and all that and went like this:
=If(F2="","",If(A2="","", DAYS(Today(),F2)/365.25))
Amazing video. Thank you for sharing
@@omarellaboudi5016 this is a great solution. I will probably steal this one if you don't mind. Thank you for sharing!
@@AdamVirgile34 By all means! Your dashboard has been such an inspiration to the system I'm using with my team, so its the least I could do
@@omarellaboudi5016 thank you so much for your kind words! I'm so glad that you and the team have gotten a bit of value!
Hi Adam, what REF!! I'm writing an "arrayformula, :A, :D"" it sayS REF! I don't understan. can you help me?
Hi! I cannot help you with this issue, but keep searching Google and RUclips - I'm confident that you will find a solution. Thank you!
Hi Adam is there a way to upload a full teams image or do I have to do them all individually
That's a great question, Eric. You have to do each one individually. Here's what I do:
- I get URL links for the images I need
- I use =IMAGE() to get the image for that URL
If you don't get the URL images, you will need to re-insert all images into new Workbooks. This isn't an answer to your question, but I thought you would like to know how I do things to mitigate manual labor if dealing with multiple workbooks.
I have one workbook that is "Profiles." In this workbook, I store all image URLs with other important profile information. I then use IMPORTRANGE to pull the "Profiles" into other workbooks that have databases and visualizations. I hope this helps!