Tagged Questions

1
vote
0answers
76 views

Conditional formatting for dates in Google sheets

I work at a language school and I have a column giving the students expected arrival date. I want to set conditional formatting to: Highlight in red any date that is older than 1 week Highlight in ...
2
votes
1answer
217 views

Date format in spreadsheet (google doc)

I want to create spreadsheets to record the money I spend each year. Each file is named as Cost-2012, Cost-2013,...etc. Inside each file, there are in fact 12 sheets, which are named as 01, 02, ..., ...
0
votes
0answers
99 views

when I importrange from one Google SpreadSheet to another, why are my dates screwed up? [closed]

The dates in the first workbook are entered as 1/1/2013. When I import the entire sheet into a different workbook, the dates are shown as a day earlier (1/1/2013 would be shown as 12/31/2012). Really ...
6
votes
2answers
405 views

Analyse frequencies of date ranges in Google Spreadsheet

I have a Google Spreadsheet where I would like to compute occurrences of date ranges. As you can see in my sheet, there is a column date_utc+1 which contains almost random date data. What I would ...
2
votes
1answer
192 views

Convert a date in Google Spreadsheet?

I have a Google Spreadsheet with a date row in UTC time, such as 12/6/2012 11:14:32 I want GMT+2 local time, so how can I convert the date in Google Drive? And, if not possible, is there a way to do ...
1
vote
0answers
115 views

How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets? Each student will use a form to enter data to sheet: "Entries" like ...
1
vote
0answers
145 views

Need count of items in one column with specific month/date in another column in Google Docs

I have been trying to use COUNTA with FILTER, but not getting correct results. The column I am counting from has text values input from a drop-down menu, which caused problems just counting until I ...
1
vote
1answer
1k views

Google Docs: Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with Dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours (I'm in a different GMT zone) Is possible to use Dates in a formula? Something like: 30/12/2012 22:15:00 ...
1
vote
3answers
7k views

Advanced date logic in Google Spreadsheets

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 ...
4
votes
1answer
706 views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
4
votes
2answers
5k views

How to sum ​​values ​​in a range of dates in Google Docs Spreadsheets?

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: ...
0
votes
1answer
106 views

Entering Local Date on Google Doc Sheets

If I use the shortcut CTRL+;, the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my Local time get pasted as opposed to ...