New answers tagged date
Use the formula =IF([cell on same row in D column] <> "", today()-[cell on same row in D column], "") So in D2 (for example): =IF(D2 <> "", TODAY()-D2, "") TODAY() returns the current date. The current date minus the specified date equals the days passed between the dates. The code above means "If D2 is not empty set current cells value to ...
This has now been resolved by Google Spreadsheets. Pasting in the date: 30/09/2013 21:15 And clicking Format > Number > Date time now immediately turns the cell into a date time cell (you can see this as it adds seconds).
The solution is to set the correct Local under the Spreadsheet's settings ("This affects formatting defaults, such as currency."). So if you want US.locale style (MM-DD-YYYY), then choose US.Locale. If you are in a different locale and want formatting
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