Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
511
questions
1
vote
0
answers
361
views
Using local date format in the references in Microsoft Word
I write a paper with Microsoft Word and use the Harvard reference style. My problem is that at the reference section, Word formats the dates in US format, but the document is in my local language, so ...
0
votes
2
answers
2k
views
Formula for Index/Match with multiple criteria WITH date range EXCEL
I am attempting to write a formula that will help pull data from column D into column H (currently populated but would be blank).
Logic is as follows: If any of the IDs in column A are in the range ...
2
votes
1
answer
2k
views
How can I make the Year/Date tag be displayed completely in media players?
I'm using Mp3Tag to tag some of my music files, and I like to use the YYYY.MM.dd format. I prefer that instead of just the year.
However, I found that both in VLC Media Player and in Groove Music, ...
8
votes
3
answers
77k
views
How to convert UTC to typical date format in Excel?
I have this UTC column called Timestamp. It looks like this.
2019-06-27T23:01:12.1024861Z
How do I convert it so it looks like this in Excel?
06/27/2019 23:01:12
If there is a formula that would ...
3
votes
1
answer
886
views
Notepad++ finding the opened time of already opened tabs [closed]
I've come across a slew of threads about adding the date or auto-inserting the date.
But how can I get the opened time of a tab that has already been opened?
1
vote
1
answer
5k
views
Excel date & Time in 24 H instead of AM/PM
I have tried many different tips and tricks to have the below date converted to 24H format in Excel 2016 with no luck. It seems to not be identified as date & time at all. Some things I tried:
...
0
votes
0
answers
32
views
Github Branch Creation Data from API
I want to analyze open source software collaborations. For my purposes I need to get the approximate point in time when a branch was created, even if it was merged afterwards. Is there a way to get ...
0
votes
1
answer
82
views
In gimp file-open menu all dates are shown "unknown"
As shown in this link:
I have windows 10, installed less than month ago. Gimp is 2.8.22 fresh install with some plugins, scripts and addons added from my previous install. New install works not ...
0
votes
2
answers
207
views
date without dashes and colons ms access + can date be part of autonumber?
I want the date (22-12-2018) without dashes and colons in Ms Access for a field.
How can I achieve it? Also is there some way to change the alignment i.e. (22-12-2018) should be 22122018 or 12222018 ...
1
vote
2
answers
38
views
How to format a fiscal quarter?
I'm trying to input financial statements into excel and want to do it quarterly. What would be the best formula that I can continue to drag right that would give me something like:
Q1'18 | Q2'18 | ...
1
vote
0
answers
214
views
In Excel scatterplot bubble charts, how do we display the year major tick as an "start of year period" rather than an "end of year period"?
I am trying to build a scatterplot chart visualization of instructor scores for a series of classes to show performance metrics, relative class size (size of bubble), plotted over time. Classes are ...
0
votes
1
answer
283
views
Google Spreadsheet Formula for Weekend Dates
In Google Sheets, what formula can I use to create a list of weekend dates where each row shows the next upcoming Sat/Sun as follows:
05/18/2019 - 05/19/2019
05/25/2019 - 05/26/2019
06/01/2019 - 06/...
0
votes
1
answer
633
views
Auto fill blank cells in Excel
I have downloaded sales data from webstore and the rows are itemised, but they only provide the date in one cell for the order.
I am trying to work out how I can auto fill the blank cells with the ...
7
votes
1
answer
9k
views
Using 'date' in bash shell to add 5 minutes to a defined time with high precision
I’m trying to keep the high (millisecond) precision of my time, shown in my $TIME variable.
I’m confused by the output I get, because I try to add 5 minutes, but it looks like it's subtracting 8 ...
0
votes
0
answers
378
views
How to delete backup files in a batch based on file name
I have created a batch file that is run on several different PCs in our organization. The batch backs up the user files and saves it on a server with the folder name being made up of the computer name ...
0
votes
0
answers
145
views
List files/folders whose name represents a date greater than
In a "backup" folder, where most subfolders are named with a date, like in the following example:
backup/
20190401/
(...)
20190429/
I want to list all folders whose name are dates ...
0
votes
0
answers
55
views
Graphing actual months in excel
I have been looking on the forum to the best of my ability and I can't find the exact answer to my question. It seems trivial though so if I have missed it I do apologize.
I have a graph were I am ...
0
votes
1
answer
4k
views
Automatically set date on remote ssh machine
I have an offline computer with no internal battery (Jetson: mini computer) that is routinely shut off and looses the current date/time. Shortly after it boots up every time, it receives a direct ssh ...
0
votes
1
answer
111
views
Centos 7 date displaying current time with plus sign
I am facing some problems. Currently i'm using centos 7, and i want to correct the date. I already set the timezone to 'Asia/Kuala_Lumpur', but i get the date with the plus sign. Eg: Tue 2019-04-16 04:...
0
votes
2
answers
3k
views
How to keep cell blank until date entered [duplicate]
So basically, "INVOICE DUE DATE" is the SUM of D11+7 ("Date invoice sent out" + 7 days as this is when the invoice is due). However, when there is no date inputted in "DATE INVOICE SENT OUT" the "...
9
votes
3
answers
5k
views
Calculating the number of days between two dates in Excel
I consider 7 days to be a week,
so if I look at 1 January 2019 - 7 January 2019,
I would say that is 7 days.
But often I seen when people are calculating the number of days between two dates or age ...
0
votes
1
answer
100
views
MS Excel365 Date/Serial Date - anyone else experiencing?
I am having a problem suddenly with all computers at my place of employment.
If I type a number into a cell (A1), such as "121218" excel is not auto-converting to a date. In addition, when the cell ...
0
votes
1
answer
1k
views
Issue with calculating date/age in Excel
Doing a project and trying to currently work out age of subjects.
I've tried using several formulas to no avail (datevalue, dateif, etc.).
I want to calculate the Age (3rd column). I've used the ...
0
votes
0
answers
81
views
Microsoft Excel change date language
I have an Excel file which checks the date in a specific value and formats it as "mmm-yy". The problem is that I'm in Spain and for the formula to work I need to change manually to "mmm-aa". I want to ...
0
votes
2
answers
268
views
Interpret dates put into Excel as mm/dd
I would like to input dates in an Excel worksheet using Swedish format dd/mm, however Excel interprets this as mm/dd. That is, writing "7/8" in a cell is converted into Excel date (2019-07-08, YYYY-MM-...
1
vote
2
answers
103
views
Unsorted dates after sorting in Excel
Sometimes, even though I sort the column dates from early to late,
some dates remain unsorted.
I fix it by rewriting the dates manually, but this is inefficient.
0
votes
2
answers
97
views
Excel switching year and month for some cells but not others
I have been given a spreadsheet with dates that are being inconsistently formatted by Excel. Since dates were entered into the spreadsheet as mm/dd/yy (i.e. no four-digit years), Excel has assumed the ...
0
votes
1
answer
2k
views
How to plot event times in a LibreOffice-calc chart
I'm trying to make a scatter chart of events, where I have day of week on one axis and time of day on another axis and the data plotted as points for each day+time event.
What I'm trying to get is a ...
2
votes
2
answers
12k
views
How can I make an Excel cell with a DATE format accept dashes?
I have an Excel sheet in which various date columns exist. Initially, all dates were in format "01/01/2000" but I wanted dashes, so I did a find-replace all expecting all the slashes (/) to be ...
0
votes
1
answer
972
views
Win 10, search file with date created in date range and type of file pdf
On Windows 10, I would like to search for file which was created between 2/1/2018 and 3/1/2018 and has extention .pdf?
I know how to search for certain date range, but do not know how to add ...
0
votes
2
answers
3k
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
1
answer
40
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
vote
1
answer
9k
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 ...
1
vote
1
answer
1k
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/...
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 ...
3
votes
1
answer
187
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
1
answer
122
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
4
answers
624
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
2
answers
753
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
1
answer
105
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
2
answers
679
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
1
answer
1k
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.
-1
votes
1
answer
96
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
2
answers
2k
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
1
answer
253
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 ...
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 ...
19
votes
2
answers
4k
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
2
answers
677
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
1
answer
49
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
1
answer
4k
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 ...