# Tagged Questions

**0**

votes

**0**answers

15 views

### Excel Command Button to change Cell Focus

I have a multi sheet workbook I use for staff rostering. Each sheet is for for a 6 month period (eg Sheet 1 is Jan-Jun 2014, Sheet 2 is Jul-Dec 2014) going back to 2010.
I have the dates along Row 3 ...

**1**

vote

**2**answers

41 views

### Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates.
I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...

**1**

vote

**1**answer

57 views

### Excel 2010 - Calculate dates and return a 0 if it is the current date or date passed

I need to calculate days between today and the 'Last day to offer' and have Excel return a 0 if today is the last day to offer or if the date has passed; otherwise it should return the number of days ...

**1**

vote

**4**answers

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

**0**

votes

**0**answers

54 views

### Filter excel pivot table using date range

I am exporting an MS Project file into an Excel spreadsheet. I would like to be able to pivot my tasks by assignee, by task etc.
I would like to be able to filter the tasks such that if the start ...

**0**

votes

**1**answer

63 views

### How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow.
After copy-pasting from pivot table and using filter to remove the blank flow ...

**0**

votes

**1**answer

470 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

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

**0**

votes

**1**answer

40 views

### Using Excel to create a date series for a job on the same 2 days every week

I want to create a calendar showing ONLY all the Wednesdays and Thursdays in a year with their date, so for example:
Wed 25 Sept
Thu 26 Sept
Wed 2 October
Thu 3 October
etc.
I thought it would be a ...

**0**

votes

**0**answers

44 views

### Format issue with dates over the 13 in excel

I have the following problem.
I'm not able to modify all dates older than the day 13.
For example:
With the date 07/01/2013 11:20:00 I am able to change the format. To 07/01/2013 11:20 a.m.
But with ...

**1**

vote

**2**answers

221 views

### Convert Day of the Year in Excel?

How can I convert Day of the Year to a mm/dd format in Excel?
Date of the Year: e.g. 1= Jan 1, 177 = June 27.
For example, how do I convert "177" to 6/27?

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

**2**

votes

**1**answer

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

**3**answers

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

**2**answers

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

**9**

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

**1**

vote

**2**answers

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