View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
John Moore John Moore is offline
external usenet poster
 
Posts: 70
Default 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.