Previous Topic Next Topic

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
Hello,

I have Purchase date and expiration date in a format of yyyy/mm/dd. I want to get the term of how long will it take from purchase date to expiration.

Example: Purchase date 2010/01/01
Expirataion dat 2011/01/01

The term of that warrant would be 1year.

How do I do that on excel without doing it maually?? I need a formulae. Please help,its urgent.

1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
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
0

Similar discussions

Facebook says I have been trying too often
Sameer -
owilson -

2 responses
Banned, need help
tk_123tk -
HelpiOS -

1 response
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
Publisher
suetjie -
ac3mark -

4 responses