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?

Thanks


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

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

=today()-mod(today()-2,7)+7
Remember to format the cell to a date