Thread: DATE & TIME
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lehigh46 lehigh46 is offline
external usenet poster
 
Posts: 43
Default DATE & TIME

Hi All,

In one cell I want to display today's date which is easy =NOW() then
format with date & time.

In another cell I want to type in a future date & time
ie. 11/14/2008 2:34 pm How do I do this?

In a third cell I want to display the difference between now & the
future date & time.

How do I do this?


Thanks for your help!

Tom