For questions concerned with obtaining, manipulating or presenting the calendar date.

learn more… | top users | synonyms

1
vote
3answers
539 views

Get DayName from Date in OpenOffice Calc?

I am having difficulty getting the day name from OpenOffice Calc. I am able to get the day Number representation from a date with the following WEEKDAY("2008-06-14"; 1) which returns 7 As we ...
0
votes
1answer
86 views

LibreCalc Date-function returns wrong month

I have a spreadsheet with three columns for "Date", "Currency", and "Amount". Date Currency Amount Month 06.02.2015 EUR 188 March 30.01.2015 EUR 285 January I ...
1
vote
1answer
7k views

Formula to update cell based on user changing another cell's content

I want to know if there is a formula to update a cell in Excel with today's date when a user changes any value in the row that contains that cell OR when a user changes the value of 6 / 7 / 8 ...
2
votes
1answer
237 views

How to change date format in multiple text files in powershell?

Hello I have around 5000 text files (TXT) in one directory.Files are comma delimited. What I'm trying to do is to change date format (it is stored in first column of each file) from M/d/yyyy to ...
1
vote
0answers
43 views

Run Query in Siebel on Modified due date

I want to run a query for open SRs by Modified due dates. I cannot find that field in normal query. Please help me out.
1
vote
1answer
309 views

Converting date Jan-12 2015 10:51AM to Date format for sharepoint use

I have a date that imports into excel from an external source as Jan-12 2015 10:51AM, but is not a friendly date format for copyinging into sharepoint 2013 datasheet. How do I convert this in excel so ...
0
votes
1answer
352 views

How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...
-1
votes
1answer
389 views

How can I tell when my computer was manufactured.?

I want to install a operating system and my computer must be manufactured between 2006 and 2014. How can I tell when it was manufactured?
1
vote
0answers
38 views

LC_date like option for excel sheet (possible in libre office)

Windows 8.1, office 2013, english interface - danish region. When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...
0
votes
2answers
385 views

Changing date on Ubuntu without sudo privilages

I am trying to automate a time change on Ubuntu 10.04 with a bash script using the date command. The script works, but it requires sudo privileges, however, the user who will execute the script does ...
2
votes
0answers
104 views

Date types management mismatch (2-digits year) - on copy/paste user action

I find a strange inconsistency when copying-pasting dates on MS Excel, when they have a 2 digits year. I work on a machine Windows 7 Enterprise 64 bit and my Excel is a 2010 version. PROBLEM ...
-1
votes
1answer
45 views

Creation date of zip file

Is there any way how can I get creation date of zip file which is stored on server? Or even better when the file was uploaded on server? I do not have access to the server disk, I can only download ...
0
votes
0answers
15 views

How to elegantly log working times by file changes

I would like to get to know some (windows) program, or some scripting lines, that could help me to get a chronological list (in the form of a text file) of file changes, on a drive or directory, ...
0
votes
3answers
276 views

How do I get the fiscal year to start on a specific date each year in Excel?

I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from ...
2
votes
1answer
286 views

Make folders' last modified date correspond to last modified date of its child folders/files

I am working with FileZilla to locate the last modified files of my website. I thought the last modified date of a parent folder will correspond to the latest last modified date of its children files ...
0
votes
1answer
711 views

NTPD not updating time date on CENTOS

I have set up ntpd on CENTOS, I am trying to get it to pull time from a Windows domain contoller if i run the command: ntpdate dc3.mydomaain.local this works fine and updates the host with the ...
0
votes
1answer
90 views

Open Office Calc - Stop date autoformatting

When I paste raw data into calc some of it converts to a date automatically (it is not date data, it simply contains a hyphen). This data is then lost because if i turn it back into text I get an ...
1
vote
1answer
91 views

Date command - adjusting the date works on my mac but NOT the server's shell

On my mac I can ask for the date in threes days time: Josephs-MacBook-Pro-3$date -v 3d Fri 3 Oct 2014 08:54:26 BST Josephs-MacBook-Pro-3$ but when I try that on my dreamhost server: ...
0
votes
0answers
58 views

Robocopy files only with a certain date

I am looking to copy files from x: to z: only if the destination file has a date changed of 9/23/2014. If the destination file has an older or newer date, don't touch it. X is my backup and Z is the ...
0
votes
1answer
395 views

How to use DATEVALUE with diffent locale setting without changing system settings

I have an Excel column that uses US date format, i.e. MM/DD/YYYY, but is a text column. I need to convert it to the date column for which I'd normally use the DATEVALUE() function. However, because my ...
1
vote
1answer
28 views

How do I have a Date format show in a Formula that is looking up that cell?

I have a formula: ="('"&A6&"','"&B6&"','"&C6&"','"&D6&"','"&E6&"')," And B6 is a date and formatted as dd/mm/yyyy (have tried all forms though) so the ...
9
votes
9answers
62k views

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column ...
1
vote
1answer
52 views

Create a non standard weekly date range autofill in excel

I am working on a monthly spreadsheet of our daily takings. I need one line for a sunday, monday and tuesday but two lines for wednesday, thursday, friday and saturday. I can't seem to hit the magic ...
0
votes
2answers
346 views

Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well). In other words, between the ...
0
votes
1answer
124 views

Looking for a formula(s) that will return the next date (higher than the starting date) from a row of dates, then the next date from that one

Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting ...
0
votes
2answers
1k 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!
1
vote
3answers
18k 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 ...
4
votes
4answers
653 views

How to use “date” to print tomorrow's day of the week

On CentOS 6 Linux I use date +%a in several cronjobs and scripts to generate logfile names like myprog-Tue.txt and this works well for me since many years. But now for one program I need to delete ...
-1
votes
3answers
87 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 ...
1
vote
2answers
553 views

How to set date for a specific program?

after june 2008 the game gears of war is giving error and not running. so when I want to play it, I need to change date about 6 years. so I'm curious is there anyway to set the time for a single ...
2
votes
1answer
407 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
2answers
539 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
3answers
190 views

Ask for date on boot (challenge)

Issue An old laptop computer with XP loses date every time it boots. It has no more battery pack so it has to be plugged permanently in to wall. What I already tried Replaced the little button ...
1
vote
2answers
3k 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
1answer
419 views

hardware clock is set but date command is displayed wrong date and time

I am setting date with settimeofday function my hardware clock is set perfectly but when i execute date command it shows me wrong date and time. but if i reboot the system than it show me proper ...
0
votes
1answer
71 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 ...
0
votes
1answer
201 views

getting todo.sh to sort due items first, then by priority

How can I get todo.sh to put items that are due: today first, then after that sort the normal way (A-Z priority then everything else)? There's this solution, but then you lose A-Z priority and have ...
3
votes
2answers
455 views

Display day of week in Taskbar without impacting Excel

With Windows 8.1, I would like the current day of the week (or abbreviation thereof) to show in my taskbar along with or alongside time and date, without ramifications for Excel and, preferably, no ...
1
vote
0answers
400 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 ...
2
votes
1answer
468 views

Batch adjust / increment file date by an offset?

Suppose I have a folder of 100 files, and they have created/modified dates that are wrong, because the real-time-clock in the device that wrote them was wrong. I want to add the same offset to the ...
-1
votes
1answer
652 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
3answers
422 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
1answer
8k 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 ...
4
votes
2answers
5k 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
1answer
6k views

Change All User short date format in Windows 2008R2 using script

I have hundreds of users in Windows 2008 R2. How can i change these user's Regional setting's short date format to DD-MM-YYYY using script ? Thanks
0
votes
1answer
37 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 ...
0
votes
0answers
44 views

My sent email is contains the current computer date for no reason

Everytime I tried to send an email through Gmail in Firefox, at the end of the e-mail, appears the current date in the format of YYYY-MM-DD HH:MM Timezone First Name Last Name Email Address: So ...
6
votes
1answer
3k views

Wrong date created for files in Windows when copying files, if the file has already existed

I'm having a problem when copying files (or creating new files) on Windows 7. If I copy a file, I expect the date created to be correct, but sometimes it's not. Usually it works, but here is an ...
3
votes
2answers
2k views

How do I pipe output to date -d “value”?

I have a date like "2014-01-30 05:04:27 GMT", and if I run date -d "2014-01-30 05:04:27 GMT", the output is in my server's timezone ("Thu Jan 30 16:04:27 EST 2014"). With the use of grep and cut, I ...
3
votes
4answers
3k views

Mac OSX Numbers - Convert text to datetime

I am using Numbers on a Mac. I have a CSV file which contains numerous dates in the format MM/DD/YYYY. I need to convert these dates into datetime format for insertion into a MySQL table. How do I ...