Questions tagged [date]

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

Filter by
Sorted by
Tagged with
65 votes
22 answers
789k 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 ...
Patrick's user avatar
  • 1,538
23 votes
9 answers
143k views

How to get the date in a batch file in a predictable format?

In a batch file I need to extract a month, day, year from the date command. So I used the following, which essentially parses the Date command to extract its sub strings into a variable: set Day=%...
AngryHacker's user avatar
  • 18.6k
31 votes
9 answers
58k 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. How do I display the time and date ...
kirakat's user avatar
  • 331
8 votes
2 answers
13k views

How can I get the date in a locale independent format in a batch file?

I'm trying to read a file that contains a date in the filename. The problem is when the date format is US in the system: mm/dd/yyyy it does not working . For this format : dd/mm/yyyy it works as ...
user3070123's user avatar
0 votes
1 answer
303 views

Linux: date cmd doesn't accept its own output string as input string?

$ date Mi 14. Jun 09:54:58 CEST 2017 $ date -d "Mi 14. Jun 09:54:58 CEST 2017" +%s date: invalid date ‘Mi 14. Jun 09:54:58 CEST 2017’ Why wouldn't the date command accept its own output string as ...
user3182532's user avatar
0 votes
2 answers
477 views

How do I tell Windows to adjust the time even if it's waaay off?

Apparently Windows 10 gets confused about what time it is - I'm pretty sure that my BIOS clock isn't getting reset, as it's just fine under Linux, and the date portion is fine it's just the hours that ...
Wayne Werner's user avatar
  • 2,323
15 votes
5 answers
11k views

Is there any software or hardware which lets you stop, slow down, speed up or even reverse time?

Obviously I'm talking about time in terms of the PC clock rather than real time. We were testing an application we've developed at work by setting the clock forward and back to simulate different ...
Tom Robinson's user avatar
  • 2,460
5 votes
1 answer
11k views

Timezone setting in Linux

I'm setting timezone GMT+6 on my Linux machine by copying the zoneinfo file to /etc/localtime, but the date command is showing the time UTCtime-6. What is the reason for this behaviour? I'm assuming ...
user avatar
4 votes
2 answers
31k views

How can I display a UTC date time value in the user's local time zone in Excel?

I have a spreadsheet with date/time values in UTC that I would like to be displayed to users in their time zone, e.g. the same spreadsheet containing UTC date/time values is provided to users in ...
Kendall Lister's user avatar
4 votes
2 answers
634 views

Excel - forecast future date based on average number of days between a variable number of dates in the past

I have anywhere from two to six dates for events in the past and based on the average spread from each one to the other, I need to predict when the next event will occur. From the screenshot, I ...
G Lee's user avatar
  • 43
2 votes
0 answers
430 views

Set system time after Suspend

After waking up (after Power Off/Log Out > Suspend) the system time is wrong (either in the future or past). $ systemctl restart systemd-timesyncd.service makes it right again. Is there a way to ...
Vladimir Zolotykh's user avatar
1 vote
3 answers
40k views

Do not refresh date in IF Statement using TODAY()

I'm using Excel 2010 and I would like to get the current date using an IF statement that does NOT refresh each time the worksheet is opened. Is there a way to do this with IF or is there another ...
Kimberly Meyers's user avatar
1 vote
2 answers
232 views

Complex Cell Formula

I want a formula that will return a date that depends on the date in another cell, but modified by the day of the week of the date in that cell. If cell A1 has a date value that is a Sunday, Monday, ...
BamaBoy's user avatar
  • 19
-1 votes
1 answer
13k views

Add Date-Time Stamp To Copied File using Windows Batch

I thought this would be simple but it seems more of a challenge than I thought. I want a file to be copied and pasted with a time stamp appended. I get the time stamp using this code: set hournum=%...
HTWingNut's user avatar
  • 499
-1 votes
1 answer
5k 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 ...
Nam G VU's user avatar
  • 12.3k
35 votes
8 answers
56k 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 ...
hendry's user avatar
  • 1,844
29 votes
3 answers
28k 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,...
LeigerGaming's user avatar
28 votes
3 answers
7k views

Why are Excel weekdays wrong for 1900?

This question is based on the observations of AdamV in his answer on How do I get the day name into a cell in Excel? When A1 has the value 2009-08-01, then: =WEEKDAY(A1) will obtain 7 =TEXT(7, "...
Jeroen Wiert Pluimers's user avatar
11 votes
2 answers
21k views

Is there any way to view dates of changes to Windows registry keys/values?

Is there any sort of date tracking that is done or viewable in the Windows registry, such as seeing the date when X key was created, or Y key was modified, similar to how file systems track? I'm ...
Coldblackice's user avatar
  • 5,884
11 votes
2 answers
11k 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 ...
theMaxx's user avatar
  • 363
10 votes
4 answers
15k views

Wrong week number in Outlook

I was stupefied to see this screen in Outlook 2013: As per ISO 8601: The ISO 8601 definition for week 01 is the week with the Gregorian year's first Thursday in it. The following definitions ...
Vojtěch Dohnal's user avatar
6 votes
1 answer
5k 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). ...
lcbrevard's user avatar
  • 578
5 votes
3 answers
12k views

Taskbar/system tray suddenly changed to 3 rows. How do I get my one row taskbar back in Windows 7?

I have Windows 7. My task bar( system tray in lower right corner) is unlocked but it will not let me drag it back into one row. The problem is the clock: the first row is suddenly time(2:30PM), ...
monikazuck's user avatar
4 votes
0 answers
3k 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 ...
Franck Dernoncourt's user avatar
4 votes
1 answer
7k 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
user avatar
4 votes
0 answers
2k views

Wrong installation date and size in Programs and Features

Nearly every fourth installed program in this list has an estimated size of 7,04GB. Also for some the date gets updated every day. The corresponding reg keys were all set to "0x0070caf9 (7391993)" ...
Felix Bernhard's user avatar
4 votes
3 answers
37k views

Batch script (cmd) resulting in DD-MM-YYYY_weekday format

I need to use date /t command and convert the date format to DD-MM-YYYY_weekday with all the "-" and "_" as listed I can't find an answer on my question. Could you please help me?
Anastasiya's user avatar
3 votes
3 answers
686 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 ...
pnuts's user avatar
  • 6,132
2 votes
1 answer
6k views

How do I write a batch script to generate folders for each month, day and year?

How do I write a batch script to generate folders for each month, day and year based on user input?
Richie086's user avatar
  • 5,191
2 votes
1 answer
4k views

How to disable day of the week in extended taskbar on Windows 10

So I have small taskbar buttons and I want to have date and hour on the taskbar. I unlock my taskbar and I extend it just a little but it doesn't show hour and date first but skips to date, hour and ...
Difrozen's user avatar
2 votes
3 answers
4k 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. ...
awe's user avatar
  • 1,121
1 vote
2 answers
2k views

Finding the MAX value over a range but if one row is blank, the value for MAX must be blank

I want to do a MAX value for the latest date in my data for the "Actual" column, but, say that one cell has no date, I want the MAX (in yellow) to be blank too. Any help would be appreciated!...
Se OKane's user avatar
1 vote
3 answers
45k 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 ...
Mawia HL's user avatar
  • 117
1 vote
2 answers
11k 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?
Daphne's user avatar
  • 11
0 votes
1 answer
3k views

How to bulk rename files in a directory using the Date column

I've got a list of a few hundred files that I need renamed by appending a modified version of the Date column to the front of the file name. The tricky part is the use of the Date column. I've tried ...
LCIII's user avatar
  • 374
0 votes
1 answer
1k views

Make a date field static after mail merge using Word

I often have to deal with mail merging (at least once a month). I use a dynamic field for inserting the Date, the problem is the dynamic field remains such even after mail merging when you save the ...
danicotra's user avatar
  • 1,984
0 votes
1 answer
135 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 ...
user avatar