This will require VBA code
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"chrisnsmith" wrote in message
...
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?