View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrianMcC BrianMcC is offline
external usenet poster
 
Posts: 3
Default update Totals using current date

Continuous daily Spreadsheet which has multiple rows of data entered during
day. Have 2 complicated Totals Fields A10 and A15 which need to only look at
data entered today (date and time is entered for each row). Has someone a
formula to cope with this as say when the database is opened in the morning
A10 and A15 will update themselves for the ongoing day.
Many thanks in advance