#sharepoint #serviceyears #microsoftlist
Hi Guys, I will show you how to create a Service Years or Counting Column for your Item Aging.
Please watch this videp on how to do it
Formula:👇
=IF(H24="","",INT((TODAY()-H24)/365.25)&" Year(s)"&INT(MOD((TODAY()-H24)/365.25,1)*12)&"month(s) and "&INT(MOD((TODAY()-H24)/30.4375,1)*30.4375)&"day(s)")
Thank you
Please subscribe if successful or comment if not.
If You Like This Video Please Don't Forget to Like, Comment and Subscribe, and Hit the Bell Button🔔 for More Updates.
_________________________
📞For Business Inquiries:
Business #: 09178475491
Facebook: / dhewada.custodio
FB Page: / tuxcustodio
FB Group: / 179834620574126
FB Group: / 417908686160013
💸Donations👇
GCash: 09454026319
📌Other Social Accounts👇
Linkedin: / dante-custodio-53421b145
Tiktok: https://www.tiktok.com/@d.e.cstudio?l...
Wix: https://danteecustodio.wixsite.com/my...
_________________________
SUBSCRIBE TO MY CHANNEL AND YOU WILL LEARN MORE.
Thank you and God Bless
________________________________________________________________________
🔊BG Music:
Youtube Audio Library: / @decstudio_ytofficialchannel
________________________________________________________________________