Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [date]

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

1
vote
0answers
3 views

Difficulty appending to cell in Google Sheets (Excel) [migrated]

My goal is to automate making a calendar on Google Sheets. I used =DATE(C1,A1,B1) to make a date and then each following cell, I added 1 to the previous cell. However, now I want to also automate ...
0
votes
4answers
80 views

Excel - Day and Date of Month

I have tried a few "Date" formulas but I cannot get this to work. Here is my issue: I want to set up a spreadsheet that will allow the user to type in A1 - the month and year. I would like my ...
1
vote
2answers
80 views

Name and date range conflict

I'm working on a project and want to calculate in excel whether the date range would conflict for a specific user. For example "employee" Bill Smith (cell B2) has a project from 10/17/2018 (Cell C2) ...
0
votes
1answer
46 views

Excel - Find the document of a given type, with the closest due date

I am operating on 2 Tables. "Table 1" is a list of current documents that I import and want to keep unchanged. The file is unformatted in any way. Table 2 is a list of customers that I operate upon ...
0
votes
2answers
28 views

How do I prevent a leading newline in Vim when using :r!date and other shell commands?

Most of the time when I'm inserting a date, I'm trying to do it in the middle of a line. By default, it looks like the :r! flavor of insertion always puts the result on a new line. This makes some ...
0
votes
0answers
33 views

Date resets to 1977 on Embeded Orange Pi running Armbian

I have an Orange Pi PC Plus board running Armbian that is not connected to the network and won't be synchronizing time through NTP. After running for few days, the date resets to 1977 without power ...
0
votes
1answer
17 views

Excel date format with abbreviated month without the dot

Hi, I am using this formula for custom date format in Excel: [$-es-ES]d-mmm-yyyy and this is what I get: 4-oct.-2018 almost fine but I dont need that dot there, how can I lose it? Thank you.
0
votes
0answers
21 views

Write Dates into array / Stop loop when reaching empty cell / Excel VBA

I am fairly new/coming back to VBA after ~10 years of Hiatus. Now I am faced with the below Problem: I would like to write Dates from a column in worksheet1 (say Colum B) into an Array until I reach ...
-1
votes
1answer
54 views

PowerShell-Script to set windows date

I can't program one line in PowerShell (I'm a linux user...). For a dev PC/Server with Windows on it, I need it to be always on one specific date (1.3.2017). Because it's a vmware vm the vm-supervisor ...
1
vote
2answers
87 views

IF condition not working in scheduled batch script

I have a scheduled batch script , based on date parameter it should run on Thu . but its not working as expected. Find the below code. ::@echo off set LOGFILE=D:\New_Folder\SCRIPTTEST\Rundaily1.log ...
0
votes
1answer
35 views

How to convert “yyyy-mm-dd” to “dd.mm” in column of text file using awk (or sed, etc.)?

Let's consider that we have the following line in text file: ... 2018-09-13 5555 33-33 Some_string ... I need to change first column (date as yyyy-mm-dd) to other format (dd.mm, dropping ...
0
votes
2answers
57 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 ...
18
votes
2answers
2k views

Excel week number inconsistent results

I am using a spreadsheet that includes the week number for a particular date. After some research, I found a function ISOWEEKNUM() that I could apply to a column of dates and this appeared to work ...
2
votes
2answers
38 views

Weird characters for date in Win 7 explorer

As per the screenshot be.ow, what would cause the date to be displayed like that but the time be fine? This is on a work computer for my girlfriend. I was helping her get a new printer/scanner setup ...
0
votes
1answer
32 views

Creating a start date formula in Excel

I have an Excel worksheet which I use to communicate to a warehouse on what date to ship an order to a customer There are two existing days I have. The first is the date I transmit the order to the ...
0
votes
1answer
35 views

Can an email's date and time be falsified in Outlook?

I received a copy of an email that shows the date and time it was sent and to whom it was sent. I have reason to believe this is not a true email. Can it be proved that the date and time sent was ...
0
votes
1answer
35 views

Excel Calculate Date Differences between Orders Per Customer

I have a data-set with Account Names, Order IDs and Close Dates. I would like to see the number of days between orders, per customer, however Excel will not allow me to sort by date in my Pivot Table ...
0
votes
2answers
60 views

change 2017/2/3 to 2017/02/03

I have a column in Excel which shows date but not in date format, it is in text format and the values for those dates that have one character for the month or day don't contain a zero before them. E....
1
vote
1answer
85 views

How do you round a time and date back to a previous day with a formula in excel?

I am trying to sum up hours for an employee worked in one shift. The employees I'm having a problem with are on night shift. The employees entries in excel are shown as individual tickets for work ...
0
votes
2answers
145 views

IExcel not comparing dates properly

I have a table with two dates in the following format: C1 Sep 21, 2017 10:22 AM C2 Sep 28, 2017 10:09 AM If I run the following if statement against them... =IF(M4<L4, "Fail", "Pass") ......
0
votes
1answer
182 views

How do you change the time of the Linux hardware (hwclock) clock to 24-hour format?

Currently, my hardware clock returns the date/time (hwclock --show) like this: Sat 28 Jul 2018 08:47:47 PM BST .659124 seconds And date returns: Sat Jul 28 21:23:13 BST 2018 I'd like to change ...
2
votes
2answers
245 views

How to corrupt a file's date modified

We have an application that works with files. The application breaks whenever it encounters a file that has no date modified / date created (the field is literally blink in explorer and via get-...
2
votes
1answer
28 views

DDD, MMMM, YYYY, HH: MM nested script in word 2016 [closed]

I need to "nest" a script to include DDDD, MMMM, YYYY, \ HH:MM to portray like this; Saturday, March 15, 2018, 09:40 AM. I know how to write the date and the time separately but I would like to know ...
0
votes
0answers
59 views

Bios date changes after Windows 7 installation in Laptop

BIOS have correct date and time, but after Windows 7 installation system show date and time 6 year earlier (2012). When you set time in Windows suddenly bios date is set to 2024. Hardware is Acer ...
0
votes
1answer
217 views

Date as X-axis in Excel

Excel "latest" version (very recent at least, with the Ribbon interface, 2018). Fighting with dates to be used as X-axis labels in a chart. The data below came out of a Pivot table; when selecting ...
0
votes
1answer
42 views

Is there a way to spoof the date metadata on folders?

I have a collection of CreativeCommons music on a USB, that I used a digital TV to listen to, but its default media player is a bit limited. It offers only two list orders (data and alphabetic), which ...
2
votes
2answers
303 views

Multiple date formats in single column in excel

I have a csv file with a date column with dates in various forms as follows: dd-mm-yyyy yyyy-mm-dd yyyy-mm yyyy This irregular data is in a single columns. How do I convert all of them to the dd-...
0
votes
0answers
23 views

Arrange and set date / time extracted from http header in router with single wget/curl line [AsusWRT / Merlin]

date -s "$(wget -qSO- --max-redirect=0 startpage.com 2>&1 | grep Date: | cut -d' ' -f5-8)" Results in the following: date: invalid date '13 May 2018 22:46:44' date -s on AsusWRT requires ...
2
votes
1answer
50 views

Excel: How to type in date and time, like “1/23/1945 16:20:14” (not Ctrl + ;)

I need to enter various time points including y,m,d,h, m, s. Examples: "1/23/1945 16:20:14" "1/23/1967 08:00" Excel only recognizes above as text, not saved as serial number. Any format for entry is ...
0
votes
1answer
158 views

Excel 2013-Force Date Format in a Cell

So, I recently ran into an issue with a customer where a column (END DATE) was formatted to be a date using the (Format Cells, Date, Type "DD-MMM-YY"), but when a user was typing in a date, they ...
0
votes
2answers
49 views

DATEDIF() not returning expected value, how can I calculate age in months?

I'm trying to calculate the age of my credit card accounts in Excel. I've read online to use the DATEDIF() function, however, I'm not getting the expected result and I'm not sure where I screwed up. ...
0
votes
2answers
81 views

Create a string using date function, with preceding zero on day and month

I am trying to create a date in VBA. I want it to display as 13.04.2018 for today's date. However, I can currently only get it to display as 13.4.2018 How do i include a preceding zero on days and ...
1
vote
1answer
88 views

Writing a formula to count how many times each date appears in a set of date ranges

Given an Excel spreadsheet with two columns: Creation Date, Closure Date For each date covered by all date ranges over all columns, I want to know how many records cover each day. For example: ...
2
votes
0answers
73 views

Excel formula to work out time elapsed between dates based on very specific criteria

I have a dataset with approx. 29,000 entries related to approx. 3000 unique individuals’ admission and departure dates to and from a service over a period of time. I’m trying to collapse each ...
1
vote
0answers
59 views

Show contiguous time periods without data in Libre Calc pivot table, pivot chart?

A minimal example: our table has sales in 2015, 2017, but not 2016. Date Sales 01/02/15 $500 10/11/17 $1000 You make a Pivot Table: Data > Pivot Table > Create Row Fields: Date Data ...
1
vote
0answers
768 views

How to change the format of a date in a Pivot Table?

I'm having an issue in my pivot table (Excel 2016). My source data contains actual dates (generated with EOMONTH function), in a standard YYYY-MM-DD format: However, my pivot table is showing a ...
0
votes
1answer
1k views

How could I change file creation/modification date from filename? [closed]

I have a bunch of pictures that each have its creation date in the filename with this format: IMG-YYYYMMDD-WAXXXX.jpg but when moved from smartphone internal memory to sd card, all the pictures got ...
0
votes
2answers
51 views

How to convert malformed dates in mixed formats?

I am working on a project to clean up my company's data. One particularly horrid file is an Excel sheet with approximately 30,000 rows. The date columns in this sheet are populated with dates in many ...
0
votes
1answer
25 views

Excel: Use date-format only on date strings that match a pattern

I'm using Excel from Office 365 I have a date column that has three types of date strings: string # 1: 12/9/2016 0:00 # this string has month, day, year, hours, minutes string # 2: 201605 # this ...
0
votes
2answers
183 views

How do I sort “2018-02-11/20:32:19” records in Excel?

I have series of data that are in format of 2018-02-11/20:32:19. And, I can't work out with formula because of "/" present without any space between date. That "/" some time creates barrier to apply. ...
1
vote
2answers
96 views

Pipe output from program to a dynamic named file (contains date)

I am still a bottle feeding linux newbie, so go easy. I've googled myself this far but can't find the answer. I'm running a program that outputs csv data, and piping it to log.csv I'm looking for a ...
1
vote
0answers
17 views

Date formulas in Excel

I have a delivery spreadsheet that contains a column with dates as well as other information. Is there a formula that can be written that would remove a row of information after the entered day is ...
0
votes
2answers
239 views

Excel Date Dependent Drop down list?

I'm creating an excel sheet that has a variety of columns, but the one in question is the dates column. Could it be done that the operator of the sheet types in todays date into say A2 (the date ...
0
votes
1answer
318 views

How to add the date in the taskbar clock without having to resize it?

I don't have much icons so I'd like to keep the taskbar minimal to save more screen space. However I'd like to have the date visible. How can I do that in Windows 7? For example, 15:31 should be 15:...
0
votes
1answer
718 views

Windows 10 - Get first logon and last logoff for each day for date range

I'm looking to see if there's a way to parse eventvwr to get the first logon and last logoff on a particular PC for each date in a range. I don't need to get any particular user... just first and last ...
0
votes
1answer
27 views

Excel Weekday Generation

I have a list of dates in a row. I just want the row above them to tell me which day of the week the corresponding date (below) fell. For example, today (30 Jan. 2018) would output "Tuesday", because ...
1
vote
3answers
940 views

How do I manually set the time to a UTC timestamp in Linux?

If I want to set the time I know I can use a command like this: sudo date +%T -s '17:45:00' And it will set the clock to 5:45pm in the system time zone. This means that if I have the system set to ...
0
votes
1answer
53 views

Outlook automatically adding in the date when I use the full stop and Enter key

Does anyone know how to get Outlook to stop autocompleting my dates when I use the full stop and Enter keys. I have to enter to get to a new line but then it automatically adds in today's date. I ...
0
votes
2answers
1k 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 ...
3
votes
1answer
183 views

Excel 2010 line chart - how to have the x axis show mmm format (e.g. Jan Feb etc)

I have a table of data, with one row for each day of the year (1/1/2018 through to 31/12/2018). I want to show this on a line chart with the x axis labelled with the short text format of the dates, so ...