# Tagged Questions

**0**

votes

**2**answers

30 views

### Comparing dates in excel

How do I compare date in the following format with today's date and work out the no. of days in between?
31.12.2016
Formula: A1-Today() doesn't seem to work. It returns #VALUE!

**-2**

votes

**0**answers

16 views

### Excel date format transposing numbers.

How do I stop Excel transposing dates?
I type in 05/11/2014 as in 5th November.
After I press return the cell displays 11 May 2014 (or 11/05/2014 depending on whether I choose numerical or letter ...

**-1**

votes

**3**answers

41 views

### Excel Formula to match dates

This may sound really simple but I need a formula that checks if one column's date is the same as another, and if so put 'true' or '1' or something. I tried =IF(H2=G2, "True", "False") but it does not ...

**2**

votes

**1**answer

56 views

### How do I convert dates from Open Office format to MS Excel format

I am trying to save a file in Libre Office as an excel file but Excel sees the data displays it as a negative number using a series of ###### symbols.
I believe the problem is to do with the two ...

**0**

votes

**1**answer

58 views

### Return day number in year from date in Excel

I am trying to show the date in an adjacent cell as the number of days in the year.
Jan 1 would be 1, Feb 1 would be 32, Dec 31 would be 365.
Also the reverse, how many days are left in the year.
Jan ...

**0**

votes

**1**answer

56 views

### Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula.
First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...

**-1**

votes

**1**answer

87 views

### Calculating Dates Backwards in Excel

I am trying to calculate 6 Fridays before a certain date, as well as 4 Fridays before a certain date, in order to establish deadlines for several departmental responsibilities. I would like the dates ...

**0**

votes

**3**answers

106 views

### How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...

**-3**

votes

**1**answer

111 views

### How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging:
Date
Running (minutes)
Pushups
Pullups
Crunches
and the rest of my workout entries.
I insert my achievements each day.
How can I script Excel to ...

**2**

votes

**1**answer

584 views

### Excel TEXT function does not work properly

Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45
A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : ...

**0**

votes

**1**answer

28 views

### Excel opens asking for a date

I am creating a spreadsheet that needs to ask the user to input a date upon opening the workbook. The answer field needs to include a valid date range that goes back 13 months.
Once a valid date ...

**1**

vote

**4**answers

589 views

### Converting text date into standard date format in Excel 2010

I've got an Excel 2010 spreadsheet that has a large number of dates for the year 2014 entered in the following format: Thursday 24th July that I need to convert into standard date time format (the end ...

**1**

vote

**3**answers

142 views

### Make Excel recognise date in custom format

How can I make Excel recognize a text in the following format as a date and time?
I have the following date in on cell:
Tuesday, December 3, 2013 1:54:26 PM +01:00
And would like Excel to format the ...

**0**

votes

**1**answer

617 views

### How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?
Excel File Origin
I have an Excel file that was originally a CSV file. At this time I don't have ...

**1**

vote

**2**answers

230 views

### Excel macros date format worldwide

On a Mac Mountain Lion, US locales, I'm working on a Spreadsheet with macros like
TEXT(TODAY(), "yyyy-mm-dd")&" is the date"
The problem is that the sheet is also used on computers set with ...

**0**

votes

**1**answer

1k views

### Excel - Convert currency as text to numbers

I frequently copy and paste HTML tables into Excel to do quick aggregate operations (e.g. sums, averages, etc).
In this example, PayPal, their HTML table contains text values like
A | B ...

**0**

votes

**1**answer

119 views

### Convert datetime to another datetime format

How do I convert this datetime?
[23/Sep/2013:21:18:00 +0200]
to
23/Sep/2013 21:18:00

**1**

vote

**2**answers

5k views

### How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...

**2**

votes

**3**answers

1k views

### Excel: show day of week does not work (German locale)

In on cell I'm showing the full date (like 01.01.2013 > German format) and in another cell I want to show only the day of week. So I followed the instructions from Microsoft which refer to the TEXT ...

**-2**

votes

**1**answer

475 views

### How to add a month to an Excel date value? [duplicate]

I tried to google for a while but it seems to have no straight forward way to do this math.
For example, we have the date at B2 12/31/2012 and need to add 2 months to it and store value in B4. What ...

**1**

vote

**2**answers

1k views

### Convert date from Taiwan to Gregorian in Excel

I've got some data from Taiwan in a .csv spreadsheet, but the dates are all in their patriotic calendar like this:
102/06/05
102/06/22
102/07/01
...
I need them in Gregorian format like this:
...

**1**

vote

**3**answers

577 views

### How to extract the time HH: MM of a cell stored as "dd/mm/yyyy hh:mm format in excel?

I.E. 01/07/2011 09:30 I would like to extract 09:30 of this cell.
How I can do it

**0**

votes

**1**answer

56 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

**3**answers

6k 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

**1**answer

187 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

**0**answers

446 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

**1**answer

426 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

**3**answers

2k 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

**3**answers

7k 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.
...

**20**

votes

**2**answers

1k views

### Why are Excel weekdays wrong for 1900?

This question is based on the observations of AdamV in his answer on How do I get the day name into a cell in Excel?
When A1 has the value 2009-08-01, then:
=WEEKDAY(A1) will obtain 7
=TEXT(7, ...

**0**

votes

**1**answer

238 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

**1**answer

144 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

**1**answer

2k 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.
...

**1**

vote

**0**answers

2k 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

**0**answers

144 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 ...

**10**

votes

**3**answers

7k 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 ...

**4**

votes

**11**answers

23k 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

**1**answer

518 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
...

**4**

votes

**3**answers

4k 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

**1**answer

2k 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

**1**answer

5k 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

**1**answer

1k 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 ...

**12**

votes

**2**answers

9k 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

**2**answers

463 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
...

**3**

votes

**2**answers

353 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

**2**answers

77 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

**3**answers

724 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

**2**answers

4k 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

**1**answer

209 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

**1**answer

2k 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 ...