View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gaurav[_4_] Gaurav[_4_] is offline
external usenet poster
 
Posts: 36
Default Count Number of Days after a Start Date

=TODAY()-A1


"Jimbo" wrote in message
...
I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days
from
now I want to display the number 3 in cell B1. Is this something you
would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim