| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PERCENTAGES | Excel Worksheet Functions | |||
| Percentages | Excel Discussion (Misc queries) | |||
| percentages | New Users to Excel | |||
| Percentages | Excel Worksheet Functions | |||
| Percentages | Charts and Charting in Excel | |||
Linear Mode
