Microsoft SharePoint List Counting the Item Service Years / Aging

Опубликовано: 04 Июль 2022
на канале: D.E.C Studio
1,981
17

#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  
________________________________________________________________________