Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
511
questions
4
votes
1
answer
347
views
What controls the output format from the command line date /t
I have two logons on the same machine. If I type the command date /t one of them shows:-
18/03/2024
and the other one shows:-
Mon 18/03/2024
I would like to have them both the same.
I imagined that ...
1
vote
0
answers
5
views
scatter graph is not displaying the date correctly for each data point
dates in my data set in my worksheet are all of the format da-mon-yr
the dates range from 22-oct-21 to 11-mar-24
the dates are sparse and repetitive. IE :
22-oct-21, 01-nov-22, 01-nov-22, 01-nov-22, ...
0
votes
0
answers
21
views
writeDate Macro not working in version 7.6.4 rev2 after years of using it
I have been using this macro for years to assign todays date as the default date to a field
when no date is selected. I downloaded version 7.6.4 rev2 and it stopped working.
REM This macro writes the ...
0
votes
1
answer
52
views
Group data by date
How can I take a list of data and group them by date?
0
votes
0
answers
52
views
excel requires one date format for cell entry but shows another
In Excel (2023) for Mac I have formatted a few fields as Date dd.m.yy. And it displays the dates in those cells as such.
BUT, it requires me to enter the date with the format m/dd/yy.
So I prefer to ...
0
votes
2
answers
50
views
Find and replace date with UTC date
I have file that looks like this:
[2024-01-20 15:23:00] hello world
[2024-01-20 15:42:00] bye
[2024-01-20 15:43:00] foo bar
...
Date in this file are in UTC+1 and I want to convert in to UTC
I tried ...
0
votes
0
answers
56
views
How to tell Excel what date format to read cells as WITHOUT changing the cell content?
I'm opening a CSV file which contains dates in the European format, dd/mm/yyyy. When opening it with Excel, Excel thinks they are in the American mm/dd/yyyy format, which makes sorting/filtering just ...
-2
votes
2
answers
406
views
need to get next Monday or Friday from a date [closed]
I have an invoice date in column A that needs to be paid next Monday or Friday whichever comes first
I need to get the expected payment date in column E
0
votes
1
answer
237
views
How to make the taskbar date show the current day of year number?
I want the clock / date area within the taskbar to show me the day of year number. E.g. February 1st would be "32" - number would be in the [1..366] range. How can I make it happen?
0
votes
2
answers
207
views
Batch file where to get date as MM.dd.yyyy for backup folder name [duplicate]
In below code I want to create a daily wise folder with hostname for backup where the date format shall be MM.dd.yyyy.
I'm using set mydate=%date:/=% and Echo %mydate% to get thedate. But I'm getting ...
0
votes
0
answers
34
views
Why does echo $(TZ=GMT+17 date +%Y%m%d%H%M%S) show me yesterday?
When I run this command today, November 8, 2023 at 1100 GMT, the output is: 20231107180000:
echo $(TZ=GMT+17 date +%Y%m%d%H%M%S)
I would have thought that, if anything, GMT+17 would ADD 17 hours to ...
2
votes
2
answers
103
views
Replace Template String with Current Date and Time in Vim
I have a template file with the following string:
{{date}} {{time24}} Some text.
I want to replace {{date}} {{time}} with the current date and time on a keymap.
I currently have:
:nnoremap <leader&...
0
votes
1
answer
17
views
Clear direct formatting does not work, how do I treat the cell with a date in it as date and no as text
A cell that contains a date, 02/30/2020, is treated as text by my formula datedif from another cell whereas other cells with similar dates are treated as dates. Deleting the content of the cell does ...
0
votes
1
answer
44
views
Days passed from the date entered
I'm trying to work out a formula.
In A1 I have any date. In B1 I have any date. In C3 I want it to return a value, which is the first part. The second is A1 has a date B1 is blank (no date). In C1 I ...
0
votes
1
answer
32
views
How to get a time edging chart with Excel?
Let's consider this example data:
time value
09:30:00 a
09:50:00 b
10:00:00 c
15:00:00 d
15:20:00 e
I would like to have a time edging graph counting the "value" column. ...
0
votes
1
answer
52
views
Windows 11: set date from text file
Per https://stackoverflow.com/a/71911192/4953146: If current_date.txt contains the today's date in the format mm-dd-yyyy. This can be used to force the date to mm-dd-yyyy:
date<currrent_date.txt
...
0
votes
2
answers
221
views
How to tell excel that a number is a date in a custom date format?
I have dates in the date format YYYYMMDD, e.g. 20230816 as of writing this question.
How can I tell excel that the number 20230816 is a date and not a number? Format cell - date does not work for me, ...
0
votes
0
answers
1k
views
Sync date & time from command line / batch file
Windows 11 (not on a domain): the setting to sync with time server is turned off. The goal is to be able to quickly execute a batch file to toggle between the current date and a specific date from ...
0
votes
1
answer
60
views
EXCEL FORMULA - Conditional format Date
I am trying to work out a formula for the below specific Critia.
If cell is blank, colour in yellow if date is 2 days away, colour in red if date has 1 day over.
I am trying to build a traffic light ...
0
votes
1
answer
62
views
I am trying to get excel to automatically insert date when another cell is changed
I have tried the following:
=IF(A1<>"",IF(B1<>"",B1,NOW()),"").
and enabled iterative calculation.
It still updates to the time when I open the spreadsheet. ...
1
vote
2
answers
627
views
How to copy files changed in last 20 days to a different location recusively
I found a code here (on this site) which allows copying of files changed in last 20 days. My issue is that I have a folder with many subfolders and some subfolders could be 8 or more levels deeps. I ...
1
vote
1
answer
380
views
How to tell which files are new or have been modified between calls of a script
I want to call a shell script regularly, and in it I need to process the files present in a directory tree that are new or that have been modified since the previous call of the script.
My 1st thought ...
0
votes
1
answer
341
views
How to calculate DocVariable In MS Word using dates
I have DocVariables in MS Word working fine, for example this gives me a date:
{ DOCVARIABLE LEGALDOCEFD \* MERGEFORMAT }
But I need to fill out an expire date, for example:
{ DOCVARIABLE ...
0
votes
0
answers
602
views
How can I preserve creation dates when packing/unpacking 7z files?
From my tests, when unpacking files from a .7z archive, 7-zip preserves the "last modified" date but sets the creation date to the time of the file extraction (unpacking).
Is there any way ...
1
vote
0
answers
83
views
adding date and time while converting m2ts to mp4 using ffmpeg?
I have many m2ts video files which were created by Sony camcorder. Because they are my family history, I want to see the date and time when I play them. But no players have such functions. I think I ...
2
votes
1
answer
162
views
Windows 11 changed Finnish date format to not include weekday, now my batch scripts won't work
I have this script that relies on getting the current day of the week from the command line..
if "%date:~0,2%"=="ma" set "weekday=true" & set "hangday=false"...
0
votes
0
answers
28
views
Formatting of dates (Days / Months) on Windows 10 / 11
I know that we have a certain amount of control in the operating system to adjust the way dates are displayed.
This issue relates to how some of the locales display:
Days
Months
For some locales it ...
1
vote
1
answer
278
views
Update cell value based on dates in other columns
I would like to:
Update a cell (A2) with a status. That could be a standardised list, for example: "Sent to Customer", "Customer Replied", "Task Closed".
There are three ...
-1
votes
2
answers
131
views
How do i convert a date, stored as text with time, as "DD/MM/YYYY"
Please can you help, I have a report, with a fixed output of "Dec 15 2022 17:00:00" as the date for each line of date; however, I need to add a column to change this data to "DD/MM/YYYY&...
0
votes
2
answers
25
views
Sort out whose who are still working by date
I have an Excel file with 4 columns: Name, Staff_No, Date_Joined, Date_Left.
My boss wants to know those who are still working.
The output should look: Name, Staff_No, Date_Joined.
Any idea for the ...
1
vote
1
answer
641
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
0
votes
1
answer
117
views
How to stop excel from displaying 3-letter months
I am running Excel (Microsoft® Excel® for Microsoft 365 MSO Version 2211) on Windows 10.
Whenever I enter a date without a year into a cell, Excel displays the month as 3-letter abbreviations instead ...
0
votes
1
answer
111
views
Auto Update Date & Timestamp in a specific cell irrespective of any data range (With or Without VBA)?
Would anyone be able to help me with this issue?
I have data based on the categories (as per spent) in specific columns & cells, i.e.,
C4:C25, F4:F25, I4:I10.
However, I want the "Updated ...
0
votes
1
answer
41
views
Excel: Custom format of date that excel cannot notice
My problem looks like this:
Dec 8, 2022, 8:35:04 AM
I need to let excel see this format as. I tried date to columns option, it didn't work. I did it in like 10 steps. Can it be done any simpler by ...
2
votes
1
answer
692
views
Using a date in an Excel function does not work when the date comes from another cell
I have the following problem: using a date as a condition in an MS Excel function works fine, as long as I write the date in the function code, such as ">1.1.2022".
But when I write the ...
0
votes
0
answers
100
views
How do I correctly format the unknown date which is probably wrong in excel?
I have this above data set in which i am pretty sure the signup_date column is wrongly formatted as it doesn't make sense for the years to be in future as the data belongs to years 2019-2021. How do i ...
8
votes
1
answer
2k
views
Firefox date format
I want to display dates in FireFox as DD.MM.YYYY, despite the fact that I'm using the en-us version of FireFox, which causes the date to be in MM/DD/YYYY format. I would like to continue using the en-...
0
votes
1
answer
176
views
How can I group photos by dates when browsing a folder via Adobe Bridge?
When browsing a folder via Adobe Bridge, one can sort photos by creation or modification dates. How can I visually group photos by dates? Eg, group of photos taken yesterday, group of photos taken two ...
1
vote
2
answers
669
views
How to combine day, week, year into a single date
I have a large dataset with three date columns: year (e.g., 2020) month (e.g., 8 for August) and week (1,2,3 or 4). I'm struggling to find a way to combine them into one date in Excel. I can only find ...
2
votes
3
answers
451
views
Parse dates like "20220928" in Excel
I have an input column which contains an id + datetime:
id12345!20220926_100911
My goal is to get the date and I have already successfully extracted the date into text with a formula involving LEFT, ...
0
votes
0
answers
89
views
Custom Date Locale in Excell
Does anyone know where the date locales are stored in Excel? I would love to be able to create a custom format (a copy of the gregorian calendar, but with different month and weekday names).
0
votes
2
answers
1k
views
Group Outlook tasks by due-date categories: "Today," "Tomorrow," "This Week," "Next Week," etc
I use Outlook's Task "peek" to organize my to-do list. When I let Outlook "Automatically group [tasks] according to arrangement," as in this picture—
—it groups them by the ...
0
votes
0
answers
824
views
Dynamic filter in PivotTable based on the system date
I have a pivot table in Excel 2016.
In the PivotTable, I want to create a filter on the data's YEAR column so that only records where the YEAR is between this year and this year + 9 are used in the ...
0
votes
1
answer
414
views
Excel VLOOKUP or INDEX MATCH with Multiple Criteria and Date Range
I have been struggling to solve this for a couple of days.
I tried some VLOOKUP or INDEX MATCH with multiple criteria but it doesn't work.
=VLOOKUP(TABLE 2B2&C2,TABLE 1 B:D,3,TRUE)
I have table 1, ...
0
votes
0
answers
3k
views
Stop Excel from re-interpreting date format on re-opening CSV
I have many large datasets that I am saving in .csv format, the input date values are in Julian format, but the final date format I want is dd/mm/yyyy hh:mm:ss. This part is simple, I just apply a ...
-1
votes
2
answers
424
views
Hijri to Gregorian not getting converted in Excel 365
I have a calendar in Hijri dates. I convert them to gregorian by typing the corresponding cell reference like =+A2. Then I format the value to gregorian date through Format Cell command. This has ...
2
votes
0
answers
430
views
Set system time after Suspend
After waking up (after Power Off/Log Out > Suspend) the system time is wrong (either in the future or past).
$ systemctl restart systemd-timesyncd.service
makes it right again. Is there a way to ...
0
votes
2
answers
1k
views
Excel date function - unknown day or month
Not sure if what I want is possible (I'd imagine it isn't as Excel likes things to be correct!), but, I have a list of items, and the date to/from they were in use. In some cases, the day and/or month ...
0
votes
3
answers
16k
views
Don't show 1900 on blank date
I have a spreadsheet that converts the date in one cell to a year in another. I want to pull the formula down so that it automatically shows the date in columns A and B if there is a date in column C; ...
0
votes
2
answers
188
views
Does date -s command ignore NTP service?
I am synchronizing time using GPSD and Chrony. However, if the time is manually changed with date -s while the NTP service is active, synchronization is not possible again.
If time is changed with ...