Today() function

  • Thread starter Thread starter chrisnsmith
  • Start date Start date
C

chrisnsmith

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?
 
I'm not sure what the TODAY() function has to do with it? If you want the
value of H1 in D1 and I1 in E1 just use the following formulas in D1 and E1:

=H1
=I1
 
Back
Top