MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Update date

Posted by Mike on March 13, 2000 5:33 AM

I have a report I update every Monday, And i want excel to right in the date for next moday automatically. Is there a macro that does this?


Posted by Jaime on March 13, 2000 6:30 AM

No macro . Just type this formula in a corner of ur sheet:

Remember to format the cell to a date