Tagged Questions
0
votes
3answers
411 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
votes
1answer
1k 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
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
...
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 ...
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
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 ...
