Tag Info

New answers tagged


Some of these solutions do not work anymore as of November 2014. Here's my solution, it will add the current date and time to any cell in your spreadsheet. Choose Tools->Script editor and paste the following, then reload your document for the change to take effect. It will add a menu in the menu bar that allows you to add the current date and time. Note: The ...


The accepted answer mentions colours that are not mentioned in the question and only looks back. Also "Date is before" "in the past week" does not highlight dates within seven days of today. I suggest a Conditional formatting Custom formula is of the type: =and(A1>today()-7,A1<today()+7) where six days before today, today and six days after ...

Top 50 recent answers are included