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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"chrisnsmith" wrote:

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?