Days culculation
 

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 01/01/2008
other cell have 30/11/2008 and the result should be show in numbers how many
remaining day from today to till last day of give future date.

Days culculation
 

=B1-A1, Format as General

--
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 01/01/2008
| other cell have 30/11/2008 and the result should be show in numbers how many
| remaining day from today to till last day of give future date.

Days culculation
 

Hi, Try this ,, I am assuming you are looking for number of days inclusding
weekends .... =DATEDIF(C3+1,D3,"d") ... assumes C3 is the start date and D3
is the end date

"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 01/01/2008
other cell have 30/11/2008 and the result should be show in numbers how many
remaining day from today to till last day of give future date.

Days culculation
 

If B1 holds 30/11/2008
The =B1-TODAY() will tell how many day there are until that date
But you need to format the cell with General otherwise it most likely will
show a date value

What do you mean by "last day" of a given date?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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
01/01/2008
other cell have 30/11/2008 and the result should be show in numbers how
many
remaining day from today to till last day of give future date.

Days culculation
 

Surprising as it may seem, the answer is simply =A3-A2, if the two cells you
refer to are A2 and A3 respectively. Excel date and time format numbers are
stored as a number of days. You'll need to format the cell with the result
as Number or General, not as Date.
--
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
01/01/2008
other cell have 30/11/2008 and the result should be show in numbers how
many
remaining day from today to till last day of give future date.

Days culculation
 

Hi, Sorry , my formula should have not included the +1 ,, I was using this
for something else. Works just as well as the others though.

"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 01/01/2008
other cell have 30/11/2008 and the result should be show in numbers how many
remaining day from today to till last day of give future date.