Hi there,
I'm looking for some help in solving the following:
I have an item that has an shelve life of 6 months, I want a formula that will calculate how many days it has remaining before it expires.
E.g.
Bottle of juice - Created 06-06-06, expires 06-12-06.
I'd like the formula to determine how many days it has remaining when given todays date.
Any help would be greatly appreciated.
Presuming the expiry date is in cell B2...
=B2-TODAY()
with expiration date in A1, try:
=A1-today()
Or with creation date in A1:
=today()-A1
I've attempted that already, however a #Value! is returned - I want the amount of days remaining to be shown in days
That should work just fine. Are your dates formatted as dates?
Perhaps you could attach a sample worksheet?
This is an example of how it should work
Hi Jason,
In Days left column, you can useand copy down.Formula:
Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks