Questions tagged [date]

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

Filter by
Sorted by
Tagged with
0 votes
3 answers
42 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; ...
user avatar
0 votes
0 answers
17 views

View date created Windows 10

The folder is only showing "Date Modified" and not "Date Created". Even when I right click-properties or right click the bar there is never a date created.
user avatar
  • 1
0 votes
0 answers
19 views

Excel PowerQuery date change not behaving as expected

hoping you can help me solve this problem. I have an Excel file downloaded from a database and I'm using Excel 2016 (yeah I know). The date column comes in as 'general' format displaying as Thursday, ...
user avatar
  • 1
0 votes
2 answers
22 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 ...
user avatar
0 votes
0 answers
27 views

Excel does not recognize an inputted date

my excel does not recognize an inputted date. For example, whether I input September 28, 2002 or 09/28/2002 or 28/09/2002, excel does not treat it as a date (or number)
user avatar
  • 1
0 votes
3 answers
34 views

Date function in Debian is IST, how do I change the default timezone of date, all the timezones are correct CEST

I have a Raspberry Pi 4 without RTC. I am using pisignage, a signage solution for the Pi. It's viewing a webpage with a time. The pi is showing the wrong time because the date command on the pi is ...
user avatar
  • 1
0 votes
0 answers
30 views

How to keep track of review dates in Excel 2010

I am trying to help my sister with Excel, but her work has 2010 and everything I suggest to her is returning #VALUE. I am currently on Excel 365 and everything I suggest to her is working for me and ...
user avatar
0 votes
2 answers
42 views

How to add Epi Week aka MMWR Week column in Power BI

My dataset has a date column. I need to assign the correct Epi Week/MMWR Week to each row. I can't do it by hand because the dataset spans five years and has over 18,000 rows. The Power Query function ...
user avatar
0 votes
1 answer
8 views

Formula to calculate multiple dates in one cell

I have two columns, one with a date ex. Nov 10. In the second column bedside it I want to a formula to calculate a list of all dates at 1 week intervals for the month. Currently I am using this ...
user avatar
0 votes
0 answers
18 views

Excel previously changed text to dates. How do I get it back to what I originally typed?

I have a large Excel (xlsx) spreadsheet full of various types of data. I had initially downloaded this data from Google Sheets. At some point (I'm not sure when), one of my columns of data that had ...
user avatar
1 vote
1 answer
301 views

Inserting Today's Date In A Cell If Other Cell Values Are Changed or Added [duplicate]

I have a spreadsheet with a column labeled, "Status Date," in a row with several other cells, some with other dates, some with just text, and others which evaluate whether a set of ...
user avatar
1 vote
2 answers
43 views

I Need To Compare 4 Dates Against Today's Date To Get A Yes Or No Result

I have 4 cells on the same row that are either blank or contain a date (YYYY-MM-DD), which I need to compare to today's date. If any one cell is blank or occurs in the past, I want the result to ...
user avatar
1 vote
1 answer
14 views

Order file by colum where column is a date

I have a file in the following format 222 aaaaa 2021-12-24 333fd bbb 2021-09-1 444 cc 2022-01-16 555 zzz 2021-08-21 6666 www 2021-09-5 777 yyy 2021-03-14 888 xxx 2021-11-27 999 ffffff 2021-12-4 I am ...
user avatar
  • 13
0 votes
1 answer
15 views

Identifying files which were created on my local system at a certain date, despite "Date created" metadata retained from installer

I've installed a program, and all the files the installer created have identical "date created" and "date modified" metadata, indicating the date that the file was last modified by ...
user avatar
0 votes
1 answer
26 views

Word field code can't calculate date less than 17 days out

I grabbed a bit of code to add in Word to calculate a date X days out from today's date: {QUOTE {SET Delay 17} {SET a{=INT((14-{DATE \@ M})/12)}} {SET b{={DATE \@ yyyy}+4800-a}} {SET c{={DATE \@ M}+12*...
user avatar
  • 274
0 votes
1 answer
51 views

Excel doesn't recognize dates

I open clean workbook and type in 2021-12-14 or any other format it will not recognize is as a date. When I type 42560 and change it to date number format I can display it as desired eg 9th of July ...
user avatar
0 votes
1 answer
42 views

get a cell in the closest row of the previous year end

I have a row in mid year which I want to get the tax value of the previous year-end row. Sometimes it will be year-12-31 and sometime there will not be that date, but a few days before it. So in B17 ...
user avatar
  • 177
0 votes
1 answer
97 views

How to change default short date format to m/d/yyyy in Excel?

Default is now d-mmmm. That means when I type 12/6 Excel prints 6-Dec. I would prefer 12/6/2021. Language/Regional format data -settings in Windows do not change short date format in Excel as far as I ...
user avatar
1 vote
2 answers
67 views

Finding the MAX value over a range but if one row is blank, the value for MAX must be blank

I want to do a MAX value for the latest date in my data for the "Actual" column, but, say that one cell has no date, I want the MAX (in yellow) to be blank too. Any help would be appreciated!...
user avatar
0 votes
1 answer
84 views

How do I show dates in UK format in an Excel when viewed in a browser?

We have a sheet on SharePoint for Daily Standup notes. If I open the document in my browser, the date format is mm/dd/yyyy (incorrect). If I open in the desktop application, the dates show as dd/mm/...
user avatar
0 votes
1 answer
80 views

MS Excel - assigning recurring weeks that reset every month

I have a set of dates say in column A and want to associate custom week numbers that reset after every 5 weeks. So for example, the week counting starts from 27/09/21 (Monday) and will end on 31/10/21 ...
user avatar
0 votes
1 answer
146 views

Bug in Excel-VBA IsDate()

The IsDate() function in Excel-VBA should recognize if a given string is/can be interpreted as a date. But this macro: Sub isdate_test() If IsDate(Cells(1, 1)) Then MsgBox "Yes" Else ...
user avatar
0 votes
1 answer
78 views

How can I prevent Excel from converting alphanumeric fields to dates?

I'm exporting alphanumeric data from a SharePoint list (single line of text datatype), but when my Excel desktop app opens the file, it changes "7-3" to "07/03/2021" and displays ...
user avatar
  • 1
0 votes
1 answer
22 views

Windows 10 time out of sync - Dualboot removed

I have been struggling with my windows 10 time for months now. It has been out of sync since I installed a Duelbooted Ubuntu OS. I tried all the solutions recommended on here that I could find but ...
user avatar
  • 1
0 votes
2 answers
87 views

Show date but not time on Windows 10 taskbar

I have disabled the clock in the Windows 10 taskbar, but this also disables the date and the "calendar button" that comes with it . I would like to have only the date there. Is there a way ...
user avatar
1 vote
1 answer
72 views

Power BI sort by column (Date) is producing different results

I have two graphs that are based off of the same dataset. I had an issue with sorting the graph chronologically, so I sorted by a YearMonNum column. The data looks something like this: id YearMonNum ...
user avatar
0 votes
1 answer
39 views

Auto-populate data

Tricky problem for me. Is it possible to use a drop-down box (or alternate tool) to select a specific week, then use this to auto-populate data into a larger data table? E.g. step 1 - select week e.g. ...
user avatar
  • 1
0 votes
1 answer
55 views

How to Calculate the Average after a certain date

Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021. can anyone help
user avatar
0 votes
0 answers
22 views

Undetected date overflow in HPE/Micro Focus Data Protector?

Some year ago I wrote some Linux script to select media (output their names) from the HPE Data Protector database. Last Friday I noticed that the script does not work any more. I did not use the ...
user avatar
  • 304
0 votes
0 answers
190 views

Infinite date column in Excel

I saw an Excel spreadsheet once that had a date column that would span a couple of month down and that would be the end of the spreadsheet, but every day you open and use it, that date at the bottom ...
user avatar
0 votes
1 answer
34 views

Using date command to print the current date

I am trying to find a way to use the date linux command to print Today is June 8, 2021 A search in man pages didn't reveal anything containing Today is in output Is it possible to use just date ...
user avatar
0 votes
0 answers
19 views

Automatically adding the date/time to a cell when another cell is updated

I haven't worked with VBA for a while now and need a little nudge in the right direction. I want my "Date" column to update when another cell in that row is edited. I've found multiple ...
user avatar
  • 101
0 votes
0 answers
23 views

Why would a file or folder have no creation or modification dates?

This is something I've tried Google-ing, but aren't sure of. I've got an app on my Mac, A Better Finder Attributes 6, which is for changing date and time of files and folders. In it, there's an option ...
user avatar
0 votes
2 answers
70 views

Excel data extraction from column

I have data from hospital on patients deaths. The data is not arranged properly, the data is as in link below All the dates should in either column DOA (H Column) or DOD (I Column) or MB (J Column) ...
user avatar
  • 3
0 votes
1 answer
125 views

How to get LibreOffice Calc to recognize dates in YYYY/MM/DD format?

I've been given a large tab-separated-values (TSV) text file that contains dates in the format YYYY/MM/DD. I tried copy and pasting the dates into LibreOffice Calc, but it didn't recognize the strings ...
user avatar
0 votes
3 answers
42 views

Excel data query

I'm trying to build out a budget monitoring spreadsheet. I want to pull sum of entries by category and based on the month. The data is in rows as follows and will grow each month as I download our ...
user avatar
1 vote
1 answer
2k views

Batch copy file with current date in file name

How to copy files from one directory to another, whose names contain current date, and so the names change daily. Example: File name: Test_14042021.txt Date today: 14/04/2021 // DDMMYYYY I tried this,...
user avatar
1 vote
2 answers
63 views

Need to simplify date entry in Excel spreadsheet

Every month I need to do a large spreadsheet for billing purposes. Among other columns I have one start date and another for end date, formatted as dd-mmm. To enter this date in the spreadsheet for ...
user avatar
  • 11
0 votes
2 answers
49 views

Output of 'date +%a' always in system-language?

Does date +%a output always the weekday in the system language? No matter if in bash, sh or cronjob
user avatar
  • 23
1 vote
2 answers
160 views

Excel won't recognize timestamp in format of "m/d/yyyy h:mm:ss AM/PM"

I have a column of timestamps (strings) formatted like so: This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM I'm trying to get them to be formatted into dates but Excel refuses for ...
user avatar
0 votes
1 answer
2k views

Plex view date history for Recently Played Movies

Plex has a list of your "Recently Played Movies" and "Recently Played Episodes": How can I view exactly when these movies were watched? Where can I see the play date of the Plex ...
user avatar
  • 3,545
0 votes
0 answers
28 views

Change Date stamp to just Month and Year

I found this simple code to copy my files and paste them into a new folder and label it with the current MMDDYYYY. I'm trying now to get it to just give me the month and year (Ex. March 2021). @Echo ...
user avatar
2 votes
2 answers
140 views

Excel: find the nearest (to a reference one) date for each row

I'm not an Excel expert (not by far) and I've been having a hard time finding a solution for the following problem. I have a table that represents the scheduled day of shift (A) for each employee (B) ...
user avatar
  • 137
0 votes
1 answer
44 views

Is there a way to automatically update a cell annually in excel?

Is there a way to update a cell automatically each year? For example, if the cell says 7, on the 31st August, it updates to 8 and so on? Thanks
user avatar
0 votes
1 answer
48 views

bash alias assignment in .bashrc for specific date command

I am trying to set an alias to show value of specific date command. When I set the alias, I get correct value, but also get "command not found..." Is there a way to set this without the ...
user avatar
0 votes
0 answers
611 views

How to manually change the Last Modified Date of a Windows file?

Windows explorer shows files and their Last Modified date, based on when they were last saved. Is there a way to manually edit that date in File Properties or through Command line, without naturally ...
user avatar
1 vote
1 answer
82 views

Win 10 Libraries option "Arrange by" won't display pictures from previous years?

It's simple as the title. On Windows 10, when I go to "Libraries", then to "Pictures" I can see folders that I included in a Library. When I open the folder, all the pictures are ...
user avatar
  • 11
0 votes
2 answers
33 views

Return value based on date

I am running into an issue where I have various sectors that have been scored differently depending on the year. See example below: 2017 2018 2019 2020 ...
user avatar
0 votes
3 answers
59 views

Translate a string date in a numeric date

I have a date expressed by string, i.e. January 28, 2021 and I would like to express it in a mm/dd/yyyy date, so from "January 28, 2021" to "28/01/2021". My approach was to ...
user avatar
  • 103
0 votes
1 answer
219 views

Show FULL WEEK-DAY NAME and FULL MONTH NAME in the Mac menu bar?

How can I show the FULL WEEK-DAY NAME and FULL MONTH NAME in the Mac menu bar? What should I change to make it possible?
user avatar
  • 1,170

1
2 3 4 5
10