Stack Exchange Network

Stack Exchange network consists of 175 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
33 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
1answer
15 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
1answer
40 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
0answers
8 views

Cannot format list of double into type of Date [migrated]

> as.Date(Dataset$dob[1]) [1] "1986-10-17" > is.Date(Dataset$dob[1]) [1] FALSE I was trying to turn Dataset$dob[1] into Date type but it seems that id does not work out. Could anyone tell me ...
0
votes
0answers
39 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
0answers
10 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
0answers
19 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
0answers
7 views

Date formats on different servers of the same language

We have English windows on all servers in our environment. Certain registry key setting is set to format like "Thu, 25 Apr 2019" on all servers, but on some servers the language is different. On some ...
0
votes
0answers
31 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
1answer
12 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
2answers
63 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
3answers
2k 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
1answer
79 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
1answer
49 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
0answers
21 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 ...

15 30 50 per page