Hot answers tagged date
5
I think I've got the solution for you. It's not done all automatically, but it will result in your proposal:
In your file the date is written as MM-DD-YYYY. I made the assumption
that the date range covers december and NOT random dates throughout
the year. Therefore I had to re-arrange the date format to
DD-MM-YYYY.
As a guidance I used the following ...
4
This works, see F35 in your sheet:
SUMIF(E2:E33;">="&E35;B2:B33)-SUMIF(E2:E33;"<="&E36;B2:B33)
column E is done by calculating a value for the dates to be able to compare them (=VALUE(E1))
Note that separating the args for some reasons is done with ;
4
Go to Settings (Cog wheel on the upper-right side)
Search for Date format
Switch to 31/12/2012
Click Save at to the or bottom of the settings page
3
Yes.
Use Conditional Formatting with three rules: (Format -> Conditional formatting)
"Date is before" "in the past week" -> red
"Date is after" in the past week" -> green
"Date is" "in the past week" -> orange
This will colour all dates more than a week away in green, all dates coming in the next week orange and the remainder of the dates in red. Empty ...
3
Google recently updated the document revisions and they are displaying the exact date for each of them. For older documents it doesn't seem to be working, but at least all your new documents will be the way you wanted it.
2
Formatting is not the answer, because it doesn't affect the underlying values. You need to make the values updatable instead.
One way is to make a reference-data place somewhere in one of your sheets (or maybe add a new sheet just for that), and put the year value in there.
Then in the first cell where you want the date values to appear, use this ...
2
It seems that this is standard functionality but only with a later version of MediaWiki than what we currently have.
Wikipedia, for example, does have this functionality.
1
1.) I don't know if there's a way to do that, except by writing some scripts (which can get pretty complex and probably not so reliable)
There's a simpler workaround, though. You could:
add a new column to the table, next to the date
store the difference (in days) between that date and today (for example, if the date cell in the first row is C2, you could ...
1
This is what can be found on Googles Help page regarding this toppic:
http://www.google.com/support/forum/p/Google+Docs/thread?tid=3a2ef6654058bbfd&hl=en
So it seems, there is no better way.
Only top voted, non community-wiki answers of a minimum length are eligible
