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.

0
votes
1answer
43 views

Excel date conversion to accounting date

Having issues convert a date in excel, to look like the following 1/1/2016. Have tried changing to a date option. Below is what i have to work with and the option to choose either of the 2. Jan 19, ...
0
votes
2answers
35 views

In Excel - how to compare a date to today's date, but ignoring the year portion?

I have a large and constantly evolving list of contact's birthdays. They all include the year, but that is irrelevant to our needs. I would like to have a cell that calculates whether a birthday (day ...
0
votes
1answer
23 views

A date which is pasted from some other source is not taken as date

In Excel 2016 when I type date as "May 02, 2008" it is taken as date but when I paste it (the same "May 02, 2008") it is not, Why?
-1
votes
0answers
27 views

Calculate date when worker will be back from med license

I want to calculate wich date workers on medical licenses will be back (including local holidays and weekends), so for example I have a worker with a 8 day license starting on 4/15/2019 and cosidering ...
0
votes
1answer
56 views

Pivot Table : How to group by date if the column headers are month names?

I have a table of expenses for multiple businesses and for each business, the expense is distributed into various accounts. The expenses are reported on a monthly basis; thus the table is provided ...
0
votes
0answers
11 views

Semantics of the date/time of an email message in various web interfaces

I'm in the process of reorganizing my e-mail workflow, and am now basing everything around mbsync and mu4e. Every now and then, however, I will need to log in to various horrid web interfaces supplied ...
1
vote
0answers
8 views

google sheets - plot of dates on timeline [migrated]

I have a column of dates, eg. 2017-01-20 2017-01-25 2017-01-27 2017-01-30 2017-02-03 ... 2018-12-20 I would like to create a plot where the x-axis is a contiguous range of dates from start to end (...
1
vote
1answer
35 views

com.apple.timezone.auto.plist moved in 10.14

In previous version of macOS you use to be able to toggle turning on and off the "Set time zone automatically using current location" from terminal by use this sudo defaults write /Library/...
2
votes
2answers
87 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 ...
-1
votes
0answers
31 views

Record data from link (OPC) and date next to each cell recorded automatically

I´ve been trying to develop a code in VBA Excel that records data from PLC link OPC, I´m trying to record downtimes and the date they were recorded, I have a code but it does not seem to work properly....
3
votes
1answer
105 views

Excel: Keep cell containing date the same after being set, without macros

I have a table that looks like this: What I want to achieve is that when you fill in a row (other than the 'Time' section), the 'Time' column automatically fills itself in. Then, it stays the same ...
0
votes
1answer
34 views

Excel formulae for priority sections

I would like to add the date C6 to E6 (if P1=30 days, if P2=60 days, if P3=90 days, if P4=1 year) and show total in I6
0
votes
4answers
82 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
84 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
51 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
31 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
37 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
30 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
39 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
58 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
88 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
41 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
58 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
46 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
42 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
36 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
86 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
272 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
207 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
282 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
33 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
64 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
354 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
45 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
394 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
25 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
52 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
261 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
55 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
83 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
78 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
61 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
1k 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 ...
1
vote
1answer
2k 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
54 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
27 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 ...