Tagged Questions
0
votes
1answer
36 views
Add rows to insert dates from a “from” and “to” column
I want to breakdown an Excel sheet by having it in a specific format.
Right now, the sheet is like this
FROM TO TOTAL
01/27/12 01/27/12 1
03/09/12 03/09/12 1
04/11/12 ...
1
vote
1answer
856 views
How can I change the default date format?
When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0".
I know I can work ...
1
vote
3answers
1k views
In Excel 2010 why can't I change the date format?
The original date is in the following format:
14/Nov/201110:53:44
I need it in this form:
14.11.2011 10:53:44
When I choose Number -> Custom -> d.m.yyyy h:mm -> OK , nothing changes.
...
0
votes
2answers
188 views
Formula to calculate the 5th [day of the week] when applicable
I've used the following formula to get the nth xday of the month:
=DATE(B2,A2,1+7*n)-WEEKDAY(DATE(B2,A2,8-xday))
where year is in B2 and month (as a number from 1 to 12) is in A2, and where xday is ...
2
votes
1answer
2k views
How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?
I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012.
I tried scrolling through the different types of ...
1
vote
2answers
323 views
Excel macro date parser cannot handle single-digit days
From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function:
Function GetDate(strInput As String) As Date
...
