# Tagged Questions

**2**

votes

**1**answer

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

**1**

vote

**2**answers

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

**0**

votes

**1**answer

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

**-2**

votes

**1**answer

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

**1**

vote

**1**answer

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

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

**0**

votes

**2**answers

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

**1**

vote

**1**answer

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

**-1**

votes

**1**answer

3k views

### Calculate age in days/months/years in OpenOffice

In need to find the age in days - months - years in OpenOffice.
There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates.
Age Calculation
...

**2**

votes

**1**answer

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

**2**

votes

**1**answer

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

**3**

votes

**2**answers

346 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

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