Skip to main content

Questions tagged [date]

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

Filter by
Sorted by
Tagged with
0 votes
2 answers
37 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 ...
EBB's user avatar
  • 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 ...
pikis's user avatar
  • 1
0 votes
1 answer
29 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 [...
freetoair's user avatar
0 votes
0 answers
29 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 ...
User1974's user avatar
  • 157
1 vote
2 answers
129 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 ...
Camila Sanchez's user avatar
0 votes
0 answers
43 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 (...
AALV8's user avatar
  • 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 ...
Ben Owen's user avatar
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 <...
FrazzleUK's user avatar
  • 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 ...
Morag Hughson's user avatar
1 vote
0 answers
22 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, ...
whburling's user avatar
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 ...
Luis Fern's user avatar
0 votes
1 answer
57 views

Group data by date

How can I take a list of data and group them by date?
Mark Adams's user avatar
0 votes
0 answers
64 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 ...
megapixel's user avatar
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 ...
sloppy's user avatar
  • 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 ...
Fly's user avatar
  • 111
-2 votes
2 answers
847 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
Ayman  's user avatar
0 votes
1 answer
452 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?
Timmos's user avatar
  • 131
0 votes
2 answers
305 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 ...
Babeesh Bhaskar's user avatar
0 votes
0 answers
56 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 ...
mscher's user avatar
  • 1
2 votes
2 answers
153 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&...
T H Wright's user avatar
0 votes
1 answer
21 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 ...
John Smith's user avatar
0 votes
1 answer
76 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 ...
PsychoPenguin's user avatar
0 votes
1 answer
39 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. ...
Tobia's user avatar
  • 2,311
0 votes
1 answer
72 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 ...
gatorback's user avatar
  • 1,225
0 votes
2 answers
372 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, ...
me.at.coding's user avatar
  • 1,587
0 votes
0 answers
2k 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 ...
gatorback's user avatar
  • 1,225
0 votes
1 answer
66 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 ...
Breanne Leopold's user avatar
0 votes
1 answer
155 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. ...
Sean9009's user avatar
1 vote
2 answers
1k 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 ...
Mohammed Khawaja's user avatar
1 vote
1 answer
727 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 ...
dargaud's user avatar
  • 220
0 votes
1 answer
482 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 ...
Giuliano Caetano's user avatar
0 votes
0 answers
751 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 ...
summerrain's user avatar
1 vote
0 answers
97 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 ...
Sanghyun Cho's user avatar
2 votes
1 answer
203 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"...
Bricktop's user avatar
  • 313
0 votes
0 answers
34 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 ...
Andrew Truckle's user avatar
1 vote
1 answer
344 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 ...
RobN's user avatar
  • 1,692
-1 votes
2 answers
151 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&...
Colin Dakin's user avatar
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 ...
hide2may's user avatar
1 vote
1 answer
1k 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 ...
totoro01's user avatar
0 votes
1 answer
244 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 ...
JoeMjr2's user avatar
  • 177
0 votes
1 answer
138 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 ...
sushil rai's user avatar
0 votes
1 answer
44 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 ...
Michał Dziepak's user avatar
2 votes
1 answer
911 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 ...
user81805's user avatar
0 votes
0 answers
119 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 ...
m srikar's user avatar
12 votes
1 answer
3k views

How can I change the date format in Firefox without changing the language in Firefox?

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-...
cxxl's user avatar
  • 373
0 votes
1 answer
203 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 ...
Franck Dernoncourt's user avatar
1 vote
2 answers
982 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 ...
ChrisMacFrance's user avatar
2 votes
3 answers
622 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, ...
Basj's user avatar
  • 1,916
0 votes
0 answers
97 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).
CraziFuzzy's user avatar
0 votes
2 answers
2k 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 ...
user697473's user avatar

1
2 3 4 5
11