1.) What is a way to use conditional formatting to get Google Spreadsheets to highlight cells that are up to 7 days away from current date? Ex: Today is 4/9/12. I have a cell with a date in the sheet ...
I can fill series of other types just like in MS Excel by extending column downwards, even if formula applied. But I can't extend series of dates. I succeeded few times, but usually I'm getting ...
I have a Google Docs spreadsheet in the format below — here's an example. Column A → Dates Column B → Numbers I'd like to sum values in column B in a range of dates in column A. Example: ...
Is there a way to use a search engine, preferably Google, that will yield results based on a date? For example, I would like to search on a term and only return results as if I was searching for that ...