Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
519
questions
0
votes
2
answers
45
views
is there a way to force minutes vs. months format
I'm working in excel and would like to create a column of sequential minutes based on a given datetime. The line currently reads:
=@daytime+(ROW()-ROW(INDEX(A$1:A1; 1)))/1440
This gives a nice ...
- 1
0
votes
0
answers
16
views
Mergefield keep together in one word
I am having data in excel and word document. In word I have field defined {MERGEFIELD my_field @ "DD.MM.YYYY"}. I am getting result 05.01.2024 in two lines for some data (this field is ...
- 1
0
votes
1
answer
35
views
How to detect even or odd minutes in bash script
I need to detect whether the current minutes are even or odd regardless of the time zone. I tried this according to answers from several sites:
#!/bin/bash
n=$(date +"%M")
r=`expr$n%2`
if [ ...
0
votes
0
answers
31
views
Date picker in Excel 2016
I have cells in an Excel 2016 spreadsheet that are date values and formatted as dates.
Is there a way to make it so a date picker pops up when a user edits a date cell? That would encourage users to ...
- 157
1
vote
2
answers
141
views
Convert month dates (with decimals) to days in Excel
Hello I have two dates, the initial one is in cell A1 (01/04/2024) and the final one in cell A2 (13/12/2024), I have looked for a formula that allows me to find the approximate number (A4) and the ...
0
votes
0
answers
45
views
LastAccessTime from where does it catch its date
Im trying to make a script to delete users that havent logged in the past 3 months locally on my pcs,but here are my doubts/problems.
My approach
I started thinking to use the properties of C:\users (...
- 1
0
votes
0
answers
16
views
=TODAY() changing previous days date [duplicate]
I want to have excel automatically put todays date into a cell which works with =TODAY(). But when I come to the spreadsheet the next day to add more data, all the cells from the previous day change ...
- 1
0
votes
0
answers
70
views
Excel treats a date in format (dd-MMM-yy) differently if typed or pasted
This was discovered when opening a file in CSV format that has a column of dates in the format dd-MMM-yy (e.g 20-FEB-24). When opening this file in Excel (Excel 365 desktop) if the 2 year value is <...
- 101
4
votes
1
answer
386
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 ...
- 425
1
vote
0
answers
23
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, ...
- 31
0
votes
0
answers
26
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
57
views
0
votes
0
answers
65
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
83
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 ...
- 3
0
votes
0
answers
100
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 ...
- 111