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 ...
0
votes
3answers
115 views
CountIf Formula that counts cells containing any and all dates without having a date range?
I need to simplify a CountIF formula.
Instead of having a date range I just need my COUNTIF to count cells cointaining dates disregarding date range period.
I have tried for example simplifying it ...
0
votes
1answer
102 views
monthly totals comparing two date columns, Excel 2010
How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)?
The spreadsheet has a column ...
1
vote
1answer
172 views
What format can I use in Excel to display both date and time in system formats
I need to display both date and time in system date and time formats.
I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...
0
votes
1answer
145 views
EXCEL populate a list of sunday's dates and ignore the sundays in an exception list
Hi i'm working on a sheet which i have to populate with sundays dates, and make sure that dates from an exception list don't be present in my final list
Goal: is to have the list of dates of only ...
0
votes
3answers
409 views
How autofill all rows between two dates in excel with the second date as the incrementing limit?
That title might have made my issue sound more complex than it is...
I am trying to figure out take one cell.... say A1 and put a date in it.... then move down several thousand rows and give another ...
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
1answer
146 views
Display date serial number using TEXT in IF
I am using an IF function to insert a string into a cell if the cell specified is #N/A, the function works if I use the following
=IF(AS2="#N/A","",CONCATENATE("insert in tempTable ...
1
vote
1answer
85 views
Excel Date Formula with a condition
I have 3 fields in excel as follows:
Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it.
I know it's very easy to achieve ...
3
votes
1answer
438 views
Importing specific date format to Excel from Microsoft SQL Server
I've already asked the question at: StackOverFlow and got sent to this place here.
I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool.
...
0
votes
0answers
956 views
Excel conditional formatting, greater than a year
I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates.
I would like if over 3 years ago, if over 2 years ago, if over 1, ...
1
vote
0answers
83 views
ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it
I haven't been able to find an answer to this.
I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) 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
7answers
5k views
How to stop Excel Treating US dates as UK dates?
I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
2
votes
1answer
333 views
Split time in arbitrary periods, EXCEL
I have a list with date and quantity of items used
IE:
2009.03.18 -1
2009.06.05 -2
2009.06.22 -1
2009.06.29 -2
2009.07.14 -1
2009.07.14 -1
2009.07.14 -2
2009.07.20 -2
2009.07.30 -1
...
3
votes
3answers
1k views
How to get the dates of the current monday, wednesday and friday of the current week in excel?
I'd just like a simple formula to return the date for the current Monday, Wednesday and Friday based on the current date.
So, I would like to see it like:
Cell A1 I'd like (Today is Monday ...
3
votes
1answer
1k views
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...
2
votes
1answer
1k views
What excel formula can I use to calculate the 2nd Monday of a given month?
What excel formula can I use to calculate the second Monday of a given month?
You can assume I have a cell containing the first day of the month to work with.
In the interests of other users, can ...
0
votes
1answer
773 views
How to convert decimal years into a date (format dd-mmm-yyyy or similar) in either Excel or SPSS?
I've found a fair number of formulas online which let me convert birthdate into decimal age in years but I can't find something that converts, for instance, 1.0 into 04-Nov-2011.
Any help would be ...
9
votes
2answers
3k views
How do I parse a nonstandard date format in Excel?
I have a column of date-like string values in the format yyyy-mm-dd, such as 2011-Sep-13. I need to convert these to Excel date serial numbers so that I can use them in formulas.
DATEVALUE isn't ...
1
vote
2answers
321 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
...
2
votes
2answers
236 views
Convert “Mon Aug 01 09:08:25 CDT 2011” to a usable date/time using Excel
I have a giant spreadsheet with computer names and the date stamp that they last reported into our PGP server that I need to convert to a usable date/time, so I can sort the column by the time the ...
5
votes
2answers
66 views
Formatting Dates
I have the following formula:
=D56&" "&"("&D57&" Days"&")"
D56 has a date within the cell. I want to format the date like 5/5/2011 but I'm not sure how to do it.
1
vote
3answers
355 views
How can I convert non-standard date data in Excel?
For some silly reason the data I've been provided has dates in the following format: mmddyyyy but if the date is something beginning with zero (e.g. 03132010) then it shows up without the leading ...
0
votes
2answers
2k views
Converting date format in formulas in Excel
I have a column of dates in the following format ddd mmm dd hh m:s "EST" yyyy. In another cell in another sheet, I wish to have the dates in the format dd/m/y. How can I do this?
I already tried the ...
1
vote
1answer
169 views
Inaccurate dates displayed in Excel (dates being calcuated from 1904 instead of 1900)
I have an excel spreadsheet containing a column of dates.
When data is copied from other spreadsheets into this spreadsheet the dates change and become inaccurate.
Changing the format of the ...
1
vote
1answer
1k views
Converting a five digit number to date format in excel?
In these spread sheets I have an entire column of values that are supposed to be dates, such as.
200701 = 1/1/2007
200702 = 2/1/2007
200905 = 5/1/2009
And so on and so forth.
These will all be in ...
4
votes
4answers
10k views
Change year in many date fields in excel?
So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question.
Is there an easy way to convert a bunch of dates I select to a ...
1
vote
3answers
279 views
check of date with functions lookup
i have input date in sheet1 say in A! 15/07/2010 and in another sheet range of dates with interval of six months in a1 01/01/2010 and in b1 30/06/2010 and c1 15 likewise data is there
i want to ...
2
votes
1answer
610 views
What date formats does Excel recognize as dates?
What date formats will Excel recognize as dates?
I've been using Jul 30/10 11:41:10 but Excel doesn't recognize this as a date.
I don't want to apply a function to the value, I just want to open ...
4
votes
1answer
289 views
How can I fix a date that changes by 4 years and 1 day when pasted between Excel workbooks
In Excel dates are represented internally by a floating point number where the integer part is the number of days since "some date" and the fractional part is how far into that day (hence the time). ...
1
vote
1answer
79 views
Return the date of the day under an if formula with Excel or VBA
I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...
