| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Future date Calculation
My one cell have today date with formula =Today() and i want total remaining
day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
If i understand correctly:-
A1 = Today() B1= 30/5/2007 c1= 31/12/2007 Put this formula in D1 and format as general =MAX(B1,C1)-A1 Mike "Qazi Ahmad" wrote: My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
=B1-A1 and format as General, not as Date, which Excel does automatically.
-- Kind regards, Niek Otten Microsoft MVP - Excel "Qazi Ahmad" wrote in message ... | My one cell have today date with formula =Today() and i want total remaining | day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 | other cell have 31/12/2007 and the result should be show in numbers how many | remaining day from today to till last day of give future date. | Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
t= datedif(first_date,Second Date,"d")
datedif() is not described in Help or just subtract the cells with the dates excel increments its dates record by 1 per day. if you need workdays only try =networkdays(first date,second date) you need to have the analysis toolpack add-in for this one "Qazi Ahmad" wrote: My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
If you have 30/5/2007 in A2, and 31/12/2007 in A3, then the number of days
from today until the later of those two dates =MAX(A2,A3)-TODAY() and format as number or general. -- David Biddulph "Qazi Ahmad" wrote in message ... My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
Thank you Mr. BJ to help me it solve my Prblem
Thank you very much "bj" wrote: t= datedif(first_date,Second Date,"d") datedif() is not described in Help or just subtract the cells with the dates excel increments its dates record by 1 per day. if you need workdays only try =networkdays(first date,second date) you need to have the analysis toolpack add-in for this one "Qazi Ahmad" wrote: My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
Thank you Mr. Mike to help me it solve my Prblem
Thank you very much "Mike H" wrote: If i understand correctly:- A1 = Today() B1= 30/5/2007 c1= 31/12/2007 Put this formula in D1 and format as general =MAX(B1,C1)-A1 Mike "Qazi Ahmad" wrote: My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
Thank your Mr. Niek to help me it solve my Prblem very simple and helpful
Answer Thank you very much "Niek Otten" wrote: =B1-A1 and format as General, not as Date, which Excel does automatically. -- Kind regards, Niek Otten Microsoft MVP - Excel "Qazi Ahmad" wrote in message ... | My one cell have today date with formula =Today() and i want total remaining | day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 | other cell have 31/12/2007 and the result should be show in numbers how many | remaining day from today to till last day of give future date. | Thank you |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Future date Calculation
Thank you Mr. David to help me it solve my Prblem
Thank you very much "David Biddulph" wrote: If you have 30/5/2007 in A2, and 31/12/2007 in A3, then the number of days from today until the later of those two dates =MAX(A2,A3)-TODAY() and format as number or general. -- David Biddulph "Qazi Ahmad" wrote in message ... My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give future date. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| future value calculation in excel | Excel Worksheet Functions | |||
| Future Value Calculation | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
