Stevie's Log 24-03-08

Today's update is a nerd alert. I save myself a lot of time at work by having a spread sheet that does almost all that my predecessor used to by manually.

We use the print out every Tuesday, when I'm meant to turn up early and print it out. That's would take about 30 minutes to prepare it (whereas the way the last guy did it took about three days).

But now I print out the sheet on a Saturday, and I don't want the date at the top of the spread sheet to let people know when I do the work. And I don't want to type in the date of the next Tuesday every time.

So I knocked up a little formula that always gives you the date of the next Tuesday. Here it is...

=7*(ROUNDUP(((TODAY()-39518)/7),0))+39518

See what a nerdy day I have had.