Formate date to TERM or warranty period
Solved/Closed
Konyeka
-
Feb 12, 2010 at 02:15 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Feb 12, 2010 at 04:01 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Feb 12, 2010 at 04:01 AM
Related:
- "Publish your article in rss format for other websites to syndicate"
- Publish an article on LinkedIn: company page, in app - Guide
- Some websites not working just on one computer ✓ - Windows 10 Forum
- Can ping but can't browse ✓ - Internet & Social Networks Forum
- Date formatting in dd/mm/yyyy ✓ - Office Software Forum
- Microsoft websites are not opening ✓ - Internet & Social Networks Forum
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2025
491
Feb 12, 2010 at 04:01 AM
Feb 12, 2010 at 04:01 AM
Hello,
I have been supposed that you have put the purchase date in A2 and the expiration date in B2:
The formula will be :
=(B2-A2)/365
and after personalize the cell format as : # ##0\[$year(s)-1]
Best regards
I have been supposed that you have put the purchase date in A2 and the expiration date in B2:
The formula will be :
=(B2-A2)/365
and after personalize the cell format as : # ##0\[$year(s)-1]
Best regards
