Calculate percentage between 2 dates with first date being =today()

Please Help

I'm trying to calculate the percentage between two dates but the first date will always be =today() and the second date will be a set date (looking at expiry dates) I've searched various excel help sites but can not seem to find an answer that works with the =today() function.

I've named the cell with =today() as Today and am trying to work out the percentage between this cell and cell O4.
Any help would be greatly appreciated as I have to present this file to the customer daily after today (hence why I was using the =today() formula rather than having to keep entering today's date (Lazy I know :-))

Hi,

Cell D1 is called Today and contains function =today() cell O4 contains 02/02/2017
I need to try and work out how many days left as a percentage between these two cells
I'll be looking at returning the % in cell Q4 as cell P4 contains the number of days left between the two dates
(this is also formula driven as O4-Today)

Does that help at all?

Thanks,

I don't really have a 3rd date as its working with expiry dates for stock. My customer wants to know the number of days remaining on the expiry date as a percentage from current date. I'm wondering if this is why I am struggling without having the 3rd date???
The expiry date varies and we have anything from tomorrow to 2018 dates

Perhaps a small sample file would better help us understand the problem, which is related to stock (Availibility??).

To Attach a File:

1. Click "Go Advanced"
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Sample file attached only data I have left in the file is date fields & hi-lighted these. Not sure if this is any help or not.

What I am after in cell R4 is the percentage of how many days left from current date (cell D1 named Today) to expiry date (Cell O4)
Cell P4 is number of days remaining from current date to expiry date.

Hopefully I have managed to attached file?

What is "Received Date": is this the third date required?

If so, use

=($O4-TODAY())/($O4-$V4)

or

=P4/($O4-$V4)

Or

=(O4-Today)/(O4-V4) (your named range)

Thanks JohnTopley.

I don't think this would work with the received date as this date isn't really taken into account apart from needing to know how long we have had the stock on our site, although it is a useful formula to remember for future ref. Reason I don;t think this would work is example. Stock was received into our site 05/10/16 but expiry date is 03/12/16, goods only have 54 days shelf life left yet it is shows as 92% for the expiry date. This is the same percentage for stock that has 260+ shelf days remaining which was received earlier in the year.

I will test it out though and get back to you if it does work, once I've tested it with a few scenarios.

So how is your stock shelf life calculated? You must have a start date so you can calculate expiry date i.e. Expiry date="start Date" + shelf life days.

what is this date:

stock that has 260+ shelf days remaining which was received earlier in the year.

So still confused about the % of "What" ?