Formate date to TERM or warranty period
Solved/Closed
Konyeka
-
Feb 12, 2010 at 02:15 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Feb 12, 2010 at 04:01 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Feb 12, 2010 at 04:01 AM
Related:
- Formate date to TERM or warranty period
- Excel date format dd.mm.yyyy - Guide
- Whatsapp date format - Guide
- Define the term digital convergence - Guide
- How to format hp laptop - Guide
- "Publish your article in rss format for other websites to syndicate" - Video Games Forum
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
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