Tag Info

New answers tagged


For Dates more than 7 days from today: Black I am assuming (i) more than 7 days in advance of today and (ii) black font is suitable – so no conditional formatting is necessary other than that applied elsewhere. For Dates less than or equal to 7 days from today: Green I am again assuming in advance of and suggest select column, Format, Conditional ...


There's an awesome script already for that! Insert > Script > search for "Today's Date" and you will find "InsertTodaysDate" which will insert today's date in the active cell. Choose Install, follow the instructions, reopen the doc and you will see a new menu item "Todays Date"


If you are willing to use a 3rd party program, I use Dash - http://kapeli.com/dash - with a Date and Time snippet. It auto replaces your snippet (mine is 'datetime') with the current date and time. This works system wide.


It’s possible to insert todays date through a macro. Open your Google Document and under Extra select Scripteditor. This opens Google's script editor where it’s possible to create macros for Google Documents. Paste this script and save it as Date Macro or something: (also available here) ** * The onOpen function runs automatically when the Google Docs ...

Top 50 recent answers are included