Microsoft SharePoint List Counting the Item Service Years / Aging

Published: 04 July 2022
on channel: 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  
________________________________________________________________________


Watch video Microsoft SharePoint List Counting the Item Service Years / Aging online without registration, duration hours minute second in high quality. This video was added by user D.E.C Studio 04 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,981 once and liked it 17 people.