Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
511
questions
0
votes
1
answer
274
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
2
answers
72
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
1
answer
304
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
3
answers
5k
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
1
answer
1k
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 ...
3
votes
2
answers
1k
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
1
answer
53
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
0
answers
86
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
1
answer
3k
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
1
answer
77
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
2
answers
8k
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-...
2
votes
1
answer
78
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
1
answer
3k
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
2
answers
2k
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
2
answers
646
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
1
answer
832
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:
...
3
votes
0
answers
174
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
0
answers
109
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 ...
2
votes
0
answers
5k
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 ...
6
votes
1
answer
11k
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
2
answers
371
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
1
answer
46
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
2
answers
199
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
2
answers
2k
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
0
answers
25
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
2
answers
1k
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 ...
1
vote
1
answer
508
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
1
answer
4k
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
1
answer
42
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 ...
3
votes
3
answers
22k
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
1
answer
618
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 ...
8
votes
2
answers
13k
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 ...
2
votes
1
answer
8k
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 ...
0
votes
1
answer
38
views
Adding a warning to `date -s` calls
I'm prone to calling date -s instead of date -d, and this can go badly when I call it on the wrong server. Is there a way to add a confirmation prompt to date -s so I realize what I've done?
0
votes
3
answers
2k
views
Linux command to filter date string from file and compare it against a date
I have a file that looks like:
ASDF,100090,D84,2007-12-29T01:07:35Z
ASDF,101090,F84,2008-01-03T01:09:36Z
ASDF,101190,h84,2008-01-04T01:07:31Z
ASDF,178915,r54,2008-01-15T01:09:21Z
ASDF,144290,k74,2008-...
0
votes
1
answer
3k
views
“Best Before” Date, 1 year into the future
How can I create a macro in Word for a “best before” date of one year from today that will repeat, just as today's date will in Word when invoked?
0
votes
2
answers
918
views
Excel, calculate +8 weeks to the nearest Wednesday (or Sunday)
We have a business process that requires us to calculate
(TODAY + 8 weeks) to the nearest Sunday or Wednesday.
For example
- Today is 07/12.
- 8 weeks is 01/02/18
- This is a Thursday. Count to ...
1
vote
1
answer
83
views
excel and birthday format
I am new to this. I do not have a screen shot for this one.
In the region I am located the birthdays are listed as: yy-mm-dd
I have: 720415 and want to convert it to: 72-04-15.
Will following work:
=...
0
votes
1
answer
312
views
Sophisticated dates sorting in MS Excel?
There is an Excel 2016 file with data about some events, the main sheet contains an ID and a date for each event, like this:
ID Date
1 2017-10-02
2 2017
3 2017-09
4 2017-09-25
… etc.
Most ...
2
votes
1
answer
1k
views
Formatting date in csv for conversion to QIF
I am hoping someone might have a solution that will allow me to save a date format in csv as dd/mm/yy. I am converting bank transactions from csv to qif - but when I import into my accounting package, ...
5
votes
3
answers
12k
views
Taskbar/system tray suddenly changed to 3 rows. How do I get my one row taskbar back in Windows 7?
I have Windows 7. My task bar( system tray in lower right corner) is unlocked but it will not let me drag it back into one row.
The problem is the clock: the first row is suddenly time(2:30PM), ...
8
votes
2
answers
16k
views
Remove 3rd row with day of week from Windows 10 taskbar
After a recent update my Windows added a 3rd row to the taskbar, showing the full day of week. I don't need it since I have one as part of the date.
Moreover, the 3rd row made my date disappear as ...
2
votes
1
answer
452
views
Configuring linux to match Human Era
Human Era (HE) is a year numbering that adds 10 000 to current AD year numbering (today is year HE 12 017). Human Era is cool because HE 0 corresponds to human’s first settlements, and HE better ...
0
votes
1
answer
597
views
If statement in Excel 2013 - if this date is 1 or more days past this date then
I'm trying to create a formula to compare the amount of days between two dates. Basically if one date (column D) is within 1 day of the previous date (column C), then "Yes" (in column E) if greater ...
0
votes
1
answer
942
views
change time zone offset without changing timezone id in linux RHEL
My current timezone is 'Africa/Khartoum' which is GMT+3:00, as per government desiccation it's going to be GMT+2:00 starting from 1st Nov. I know I can change my current date to be an hour earlier but ...
1
vote
2
answers
232
views
Complex Cell Formula
I want a formula that will return a date that depends on the date in another cell, but modified by the day of the week of the date in that cell.
If cell A1 has a date value that is a Sunday, Monday, ...
0
votes
2
answers
889
views
Excel sort dates to be in oldest to newest without changing grouping
I have a list of customers with due dates and corresponding payment dates but the payment dates weren't updated in the correct order. Is there a way I can sort the payment date to be in order without ...
1
vote
1
answer
626
views
How do I add 1 month to a specific date once that date has passed?
I have an excel sheet that lists our current due date. The due dates are the same day of each month (9/2, 10/2, etc) and I want the due date to update once the old date passes so I don't have to do ...
0
votes
0
answers
115
views
Undoing Text Formatted as Dates
I imported a TXT file into Excel.
Some of the entries, in the format 11-2, were treated as dates by Excel.
I did not catch this until it was too late, but Excel also overwrote my original data with ...
10
votes
4
answers
15k
views
Wrong week number in Outlook
I was stupefied to see this screen in Outlook 2013:
As per ISO 8601:
The ISO 8601 definition for week 01 is the week with the Gregorian
year's first Thursday in it. The following definitions ...