Hi
Just wondering if anyone new a cool way to calculate the product life and display it in either days months or years (most suitable)
ive attached a spreadsheet that just displays it in days.
If anyone could point me in the direction that'd be great thanks!
Hi,
Why not just format the cell as appropriate. e.g for years : months : days specify in the custom format
"y : m : d"
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks for that. yep, ill do it that way
maybe this?
If you've not used Datedif( before, type it exactly as i've done. It's an old formula that doesn't have any supporting helpfile within excel but it does the trick
Last edited by scottylad2; 11-08-2010 at 10:29 PM. Reason: further info
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks