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, duration hours minute second in high quality that is uploaded to the channel D.E.C Studio 04 July 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,981 times and liked it 17 visitors.