dates as percentages
 

I really need to make a calculator out of excel to calculate a percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

Days remaining =A2-TODAY()
% remaining =(A2-TODAY())/(A2-A1)
--
David Biddulph

"minimoi" wrote in message
...
I really need to make a calculator out of excel to calculate a
percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus
the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

Try

=DATEDIF(TODAY(),A2,"d")/DATEDIF(A1,A2,"d")

Format as %

Mike

"minimoi" wrote:

I really need to make a calculator out of excel to calculate a percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

But of course with days you don't need DATEDIF, Mike. A simple subtraction
will do the job.
--
David Biddulph

"Mike H" wrote in message
...
Try

=DATEDIF(TODAY(),A2,"d")/DATEDIF(A1,A2,"d")

Format as %

Mike

"minimoi" wrote:

I really need to make a calculator out of excel to calculate a
percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus
the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

Many thanks for your swift replies, superb worked a treat both ways, my only
gripe(lol) is that it does not show the percentage sign in the total? any
further help? please.

"Mike H" wrote:

Try

=DATEDIF(TODAY(),A2,"d")/DATEDIF(A1,A2,"d")

Format as %

Mike

"minimoi" wrote:

I really need to make a calculator out of excel to calculate a percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

Hi,

As soon as i saw your response I realised i'd gone OTT.

Mike

"David Biddulph" wrote:

But of course with days you don't need DATEDIF, Mike. A simple subtraction
will do the job.
--
David Biddulph

"Mike H" wrote in message
...
Try

=DATEDIF(TODAY(),A2,"d")/DATEDIF(A1,A2,"d")

Format as %

Mike

"minimoi" wrote:

I really need to make a calculator out of excel to calculate a
percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus
the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

It will if you format as %

"minimoi" wrote:

Many thanks for your swift replies, superb worked a treat both ways, my only
gripe(lol) is that it does not show the percentage sign in the total? any
further help? please.

"Mike H" wrote:

Try

=DATEDIF(TODAY(),A2,"d")/DATEDIF(A1,A2,"d")

Format as %

Mike

"minimoi" wrote:

I really need to make a calculator out of excel to calculate a percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.

dates as percentages
 

sorry, me being stupid!
"Mike H" wrote:

It will if you format as %

"minimoi" wrote:

Many thanks for your swift replies, superb worked a treat both ways, my only
gripe(lol) is that it does not show the percentage sign in the total? any
further help? please.

"Mike H" wrote:

Try

=DATEDIF(TODAY(),A2,"d")/DATEDIF(A1,A2,"d")

Format as %

Mike

"minimoi" wrote:

I really need to make a calculator out of excel to calculate a percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.