Re: Days culculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <QaziAhmad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:02DE18AC-1F71-4AB8-BCBC-21657BB88E1B@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)
  • Excel 07 - text displays as pound signs
    ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ... any given cell will suddenly appear as all pound signs. ... changed the format to a date. ...
    (microsoft.public.excel.newusers)
  • Re: Date and Time (entering in the format of mm/dd/yyyy and hh:mm:
    ... you can't format the difference to show mm ... Elapsed time is the difference between two times. ... In cell A1, ... On the Home tab, in the Cells group, click Format, and then click ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)