Microsoft SharePoint List Counting the Item Service Years / Aging

Channel:

D.E.C Studio

Subscribers:

14,700

Published on July 4, 2022 1:10:33 PM ● Video Link: https://www.youtube.com/watch?v=nGffklzq0vk

Duration: 4:54

408 views

8

#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: https://web.facebook.com/dhewada.custodio/
FB Page: https://web.facebook.com/tuxcustodio/
FB Group: https://web.facebook.com/groups/179834620574126/
FB Group: https://web.facebook.com/groups/417908686160013/

💸Donations👇
GCash: 09454026319

📌Other Social Accounts👇
Linkedin: https://www.linkedin.com/in/dante-custodio-53421b145/
Tiktok: https://www.tiktok.com/@d.e.cstudio?lang=en
Wix: https://danteecustodio.wixsite.com/myinfo/

_________________________

SUBSCRIBE TO MY CHANNEL AND YOU WILL LEARN MORE.
Thank you and God Bless

________________________________________________________________________
🔊BG Music:
Youtube Audio Library: https://studio.youtube.com/channel/UCoS0D2fTf-802YLV5SgzqMw/music
________________________________________________________________________