The tag has no wiki summary.

learn more… | top users | synonyms

15
votes
7answers
22k views

Windows 7 - display date using small icons

I recently upgraded to Windows 7 and need the date displayed with the time. This works, but only if I use large icons in the taskbar settings which is quite ugly. Any ideas how to display the time ...
3
votes
1answer
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
1answer
463 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 ...
4
votes
1answer
4k views

Setting file creation date in Mac OS X

I need a script to set the creation date to the modification date for a bunch of files created by my sound recorder - any way to do this? Running Mac OS X 10.4.11
5
votes
4answers
4k views

Timezone conversion by command line

I know about http://www.timeanddate.com/worldclock/converter.html I can't figure out how to query http://www.google.com in a sane natural format like "5pm BST in PST". Or do I have to write such an ...
4
votes
11answers
22k 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 ...
4
votes
1answer
531 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). ...
2
votes
3answers
2k views

How to get date value in commandline

I need to do a command that takes yesterday date and builds it into a file path like this: copy "Something 2010-12-06\*.zip" "d:\Copy\" where 2010-12-6 is yesterday's date in format yyyy-mm-dd. ...
1
vote
1answer
50 views

How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in ...
2
votes
1answer
541 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 : ...
1
vote
0answers
62 views

How to find out when an audio disc (CD) has been written/burned?

Is there a way/tool to determine the date and time when an audio disc (CD) has been written/burned? I am aware of How to find out when a disc (DVD) has been written/burned? but the accepted solution ...
1
vote
2answers
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
1answer
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 ...