Today() function

[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?

 

[Bernard Liengme]

This will require VBA code
best wishes

 

[Shane Devenshire]

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