View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chrisnsmith chrisnsmith is offline
external usenet poster
 
Posts: 96
Default Today() function

I have a worksheet with columns D thru I. In Cell M2 I have the Today()
function.

What I need is a formula that will transfer info from columns H and I to
columns D and E automatically when date changes tomorrow.

Can this be done?