Thread: Todays date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Todays date


Thank you
"excelent" wrote:

=DAYS360(TODAY(),$A$91)+1-ROW(1:1)

Where A91 is August 15


"Kevin" skrev:

Column A has dates in it May 17 to August 15 in column J is how many days
until August 15th. In J3 I would like to have the number of days until August
15th from todays date, tomorrow, tomorrows date and so on. Is there a
formula for Excel to do this automatically?