MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking the date to sums

Posted by fraz on January 23, 2002 11:32 AM

I need to link the date to a sum, whatever the date happens to be without entering it into the worksheet

Posted by Joe Was on January 23, 2002 12:17 PM

=SUM(D1:F1) & " " & TEXT(TODAY(),"mmmm dd, yyyy")

Put this in the cell that you want to sum, change the range! JSW

Posted by cheruan on April 29, 2002 5:59 PM