View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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.