Days culculation

[Qazi Ahmad]

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.

 

[Niek Otten]

=B1-A1, Format as General

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[John Moore]

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

 

[Bernard Liengme]

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

 

[David Biddulph]

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.

 

[John Moore]

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.