Questions tagged [date]

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

Filter by
Sorted by
Tagged with
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 ...
Gergely's user avatar
  • 125
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 ...
user1057669's user avatar
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, ...
Unknow0059's user avatar
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 ...
Brigitte1Trick's user avatar
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?
Nathan Spicer's user avatar
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: ...
John Heinonen's user avatar
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 ...
NiklasRz's user avatar
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 ...
baviros's user avatar
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 ...
NewAtSQL's user avatar
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 | ...
user3628240's user avatar
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 ...
Wibble's user avatar
  • 119
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/...
THE DOCTOR's user avatar
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 ...
ShadowFingers's user avatar
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 ...
Volumetricsteve's user avatar
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 ...
TX_Balloon_Grl's user avatar
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 ...
Ninj's user avatar
  • 101
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 ...
user avatar
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 ...
Blaine's user avatar
  • 1,687
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:...
maximran's user avatar
  • 103
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 "...
TEE's user avatar
  • 3
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 ...
Naz's user avatar
  • 405
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 ...
D.ozer's user avatar
  • 1
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 ...
Johnny's user avatar
  • 11
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 ...
Santiago Veintimilla's user avatar
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-...
Toivo Säwén's user avatar
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.
Alvaro Morales's user avatar
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 ...
Mallika's user avatar
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 ...
Gordon's user avatar
  • 101
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 ...
Nikos's user avatar
  • 141
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 ...
user1700890's user avatar
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 ...
Blobby's user avatar
  • 3
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?
MASTREX's user avatar
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 ...
Nizar's user avatar
  • 13
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/...
Dash's user avatar
  • 111
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
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 ...
Geza Kerecsenyi's user avatar
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
Jez's user avatar
  • 1
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 ...
Grungefreak's user avatar
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) ...
SiniSter's user avatar
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 ...
Marcin's user avatar
  • 1
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 ...
sbseltzer's user avatar
  • 105
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.
Cain Nuke's user avatar
  • 179
-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 ...
philipp's user avatar
  • 31
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 ...
RajuK's user avatar
  • 11
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 ...
N0rbert's user avatar
  • 121
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
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 ...
WPDavid's user avatar
  • 193
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 ...
Philip Ward's user avatar
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 ...
Ted's user avatar
  • 1
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 ...
Teresa O'Brien's user avatar

1 2 3
4
5
11