I'm struggling to do something in a spreadsheet (I'm using Google Spreadsheets, but could use Mac Excel or Numbers if needed). I want to automatically fill one cell with the name of the calendar quarter (e.g. "Q3-2015") based on a user-entered date in another cell. To make it more complicated, the "quarters" don't begin/end on standard dates. [more inside]
Help me identify a TV comedy about a regular dude who's dating a famous woman. [more inside]
I haven't been feeling so confident lately. I know my SO could also be much happier if she felt a bit more confident. When we first met around 3 years ago, we were both extremely confident. Now we seem to have trouble being decisive, making decisions to better ourselves/get necessary things done, and choosing a restaurant or a date idea gets harder and harder. I would love ideas of things that could help with this. [more inside]
I bought a box of 2 pounds of Fancy Amary Dates at the imported food store, because they were the cheapest. Now I know why - they're kind of tough and fibrous and not very sweet. Normally I can finish off a box of dates in a week, but these ones are going slowly. What can I do to redeem these dates?
Help settle this bet/communication issue. Pretend it's this past Monday, July 14th. You and several friends get an email about another friend's upcoming birthday party. The note says the party is next Saturday. Do you think the party is Saturday the 19th or Saturday the 26th?
Am wary of buying these online, as I am looking for fresh, malleable, amber deliciousness. Anyone know any retailers in the LA/Orange County area? I have tried some Middle Eastern markets so far, but to no avail, if that helps. Thank you!
Looking for good, reasonably priced, activity dates in the NYC area. What do you do when you're not doing dinner and a show? Hands-on is preferred - active rather than passive activities. [more inside]
Hi everyone, about a month ago, I asked metafilter whether this girls likes me and whether we were going on a date. I followed everyone's advice and straight up asked her on a date, but now I'm not sure what's going on. Sorry for the wall of text, but I'd like to give you all the details of what happened. Please be aware that this is from my perspective. [more inside]
I have a list of films as a text file. Is there a website which would allow me to import the list and assign release dates probably using an IMDb api? [more inside]
I have a paper advertising item which, I am told, was printed by Carlo Belloni in Milan, Italy. The item appears to be from around 1920 to 1940 or perhaps earlier. For dating purposes, I would like to know when this printer was in operation. TIA
How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
After years and years of agony, we're quitting iPhoto for OS X. For now, we're using Lyn plus existing cloud backup rather than paying another monthly nut for Dropbox or the like. The only problem is, I like that when iPhoto imports photos, it organized them by year, month and day. I'd like to find a way to replace this functionality -- Apple script, existing software, whatever -- without actually importing them into iPhoto.
What's the friendliest way to decline future dates from someone you've been out with a few times but just aren't that into? [more inside]
Dates are pretty tasty, but I only see US-grown Medjool dates at the store. Wikipedia claims there are many more varieties. Where can I find other kinds of dates in or near San Francisco? [more inside]
Need some ideas on activities I can do with my girlfriend. [more inside]
Bloomsday, Festivus, Pi Day, Caturday, Diwali, Poisson d'Avril--what are some other less traditional (or less familiar to a USian) holidays that might be fun to mark on the calender to celebrate? [more inside]
Candy-making wizards, help me save this date candy recipe that didn't set properly (or tell me I'm screwed and should start over from scratch). [more inside]
Surely some mefite is an Elton John enthusiast who can tell me when he played a show at (probably) Exhibition Stadium in Toronto in the early nineties, or else set me right on this. [more inside]
In Excel 2007, is there a way to highlight all cells within a certain range (in my case, five adjacent columns) that contain dates in the future? [more inside]
I have an antique French olive oil label. The printer's name and location appear in small print at the bottom: "Panet & Imbert" - Marseille". I would like to know when this printer was in operation. I have not found anything useful about this on the Internet.
Information on JLLERT (German printer?). I have an old German olive oil label. I am trying to determine just how old it is. In small print, it reads "JLLERT No. 7516 (or 4516)". I suspect that JLLERT is the printer's name. The label was used by August Grill (Schorndorf), a store that was in operation from 1912 to 1965. I would like to know when JLLERT was in operation.
Excel Pivot Table Help - My google-fu and excel-fu have failed me, I'm working on a tracking pivot table that will display total number of attendants in a class (broke out in gender) for each day based on a start and end date. [more inside]
I bought a couple of Twinkies today and just noticed that their expiry date is August 2007. My SO has misgivings about eating something so, well, old. I contend that Twinkies are basically Cold War-era bunker spec foodstuffs. So: Perfectly Fine, or Deadly Poison?
Which important human milestones 3 - 10 years out have a known date of occurance? I'd like to add them to my calendar.
Intermediate Future Calendar: After adding the 2015 New Horizons flyby of Pluto to my Google Calendar [14 July 2015; 11:47 GMT], I was filled with a desire to populate the semi-distant future -- say, the next +3 to +10 years -- with important human achievements/milestones that have a known date. What are these important dates? [more inside]
Fun, nerdy, date ideas in Ottawa, On? [more inside]
My 82 year old brother can't recall his dates of military service. He was in the U.S. Air Force in the 1950's and left with an Honorable Discharge but he can't recall the dates. Can anyone give advice as to how these dates could be ascertained? What agency should be contacted and can it be done online? Thanks.
When a sentence includes a date (month, day, and year), is it always proper to set off the year with commas? [more inside]
Does picking up women outside of bars and clubs work? A woman's opinion is appreciated. [more inside]
dating filter: as a girl, how little initiation in dating is too little initiation? [more inside]
In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]
Haven't seen my SO in 6 months. Arriveing in Bristol, UK for the first time in a few days. Want to take her somewhere romantic, awesome and private for dinner / drinks. Suggestions?
Never dated someone I didn't already know. Some advice on dating protocol? [more inside]
Please explain these old newspaper customs regarding days and dates. [more inside]
What is the protocol for cancelling a date? [more inside]
It’s my boyfriend’s birthday next week. Yay! Along with presents and activities lined up, I really really want to make him a series of date envelopes. So, he’ll get 12 envelopes, each one to be opened on the first of the month, for the next year. And in each envelope will be a piece of paper with a super fun thing for us to do together. The sticking point is, um, the super fun things. Kind, funny, romantics AskMe, will you hope me plan 12 months of super fun? Yes? Let's go! [more inside]
Good weeknight date ideas? [more inside]
Where to drink beer in Los Angeles? [more inside]
What are some good creative date ideas for the weekend? (3rd date) [more inside]
Went on two great dates with a girl I really liked. Texted for a third date and didn't get a response. Move on? Or reach out one last time? [more inside]
Where can I get awesome dates? (The kind you eat, not the kind you go on). NYC or online. [more inside]
Excel question: How can I tally by quarter when all I have are dates? Bonus challenge details inside. [more inside]
Historical dates for blog posts? [more inside]
I'm trying to use the Google App Engine to make a Java program that goes to Southwest.com every six hours, enters in two airport codes (i.e. JFK and LAX) and two dates (i.e. 7/22/2011 and 7/29/2011) into the text fields on that webpage, and parses the HTML of the results page to find and store the lowest price on the page. I need some help getting started. [more inside]
How common is it for settlement (on a house purchase) to be delayed? [more inside]
Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date. [more inside]
Calendar math question: today is March 25, 2011. I found my old watch in a drawer and the time is still correct, but the watch date window says 13. Assuming the date window repeats 1 to 31 and that I always 'set' my watch correctly, what was the most recent month and year that I could have worn it? [more inside]
What are the historical dates you are always glad you remember? Are there any well-recognized, history book dates that help you pin your sense of history together more than other dates do? [more inside]
Please give me some hope. [more inside]
Non-bar first date ideas in (mostly eastern) Queens? [more inside]
My boyfriend of over a year and I have a great relationship. One of his best qualities is that he's so easy-going, but that's also led to an annoyance: he rarely takes the initiative to plan our dates anymore. [more inside]
Page: 1 2