Questions tagged [date]

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

Filter by
Sorted by
Tagged with
2 votes
2 answers
3k views

Excel, use conditional formatting to highlight dates in current fiscal year?

In Excel 2016, I'm trying to use conditional formatting to highlight dates in a current fiscal year, but I can't figure out how to write the formula correctly. The fiscal year goes from 10/01/19 to 09/...
Rebecca's user avatar
  • 51
1 vote
2 answers
3k views

Excel date format changes with different regional settings (2020-08-01 to 2020.08.01)

I searched most of the posts, but there is no solution to my problem. This is what I tried using Excel 365 with English Windows Machine: And this is what I get when I open the file with Excel 365 on ...
schluk5's user avatar
  • 11
0 votes
1 answer
73 views

Creating "semi-regular" lists of dates in Excel

Consider the Excel power user club of Wheatland, Wyoming. The club meets evey Thursday, plus every second Monday. So there are, alternating, weeks with two, and weeks with only one meeting. Let us ...
Nils L's user avatar
  • 103
0 votes
1 answer
231 views

Dates in between the Date Range - SQL Server

I have a table which holds: PlaceID, STARTDATE, ENDDATE, OCCUPANCY 100, Jan 1, Jan 10, Occupied 100, Jan 15, Jan 20, Occupied 100, Jan 11, Jan 14, Empty 100, Jan 21, Jan 31, Empty 200, Jan ...
Jeni's user avatar
  • 3
0 votes
1 answer
489 views

Excel PivotTable Date Grouping in 24-hr Center

I am attempting to analyze data of agents working in my company that runs 24/7. I was going to construct a pivot table to show the daily operations of each individual. This fit most of my needs ...
Brian Silva's user avatar
0 votes
1 answer
243 views

Command 'date +%W' does not return week 00

Manual page for date(1) says: %W week number of year, with Monday as first day of week (00..53) I assumed there exists a week number 00, and I handle such week in my program, but once I decided to ...
Damian Roszczyk's user avatar
0 votes
0 answers
30 views

Create Appointment Calendar from Master Spreadsheet

We have an old doc that struggles with Excel. We track his appointments and other pt specific information in Excel. However, the entire Excel spreadsheet is too complicated for him to deal with. I'...
Mitch R's user avatar
2 votes
1 answer
949 views

Why does Excel now require a slash for dates and how do I change it back so it does not?

I used to be able to type a date without any separators, ie 062509 and Excel would recognize it and return the date in whichever date format I selected, such as June 25, 2009 or 06/25/2009. Now Excel ...
Grace's user avatar
  • 21
0 votes
1 answer
3k views

Can not display date as MMM-YY in Power Pivot chart

Currently I am working on an excel data model which have several Power Pivot Chart in it. I need to make the date format of the axis become MMM-YY (ex: Mar-19) but can not. Current chart format with ...
Lucas's user avatar
  • 1
0 votes
3 answers
355 views

How to find which column contains the first occurance of a number in a single row? (Excel)

I have an Excel sheet with over 100 dates as column names and hundreds of locations as row names. There are numbers (could be any number) somewhere in each row that indicate that an event will occur ...
AmericanAnalyst's user avatar
0 votes
1 answer
69 views

Plotting of timeseries (ISO8601) in LibreCalc

I have a CSV file with: 2020-30-05T23:23 10.000 2020-31-05T09:46 20.000 2020-31-05T13:45 30.000 2020-31-05T19:10 40.000 2020-31-05T23:22 50.000 2020-01-06T09:45 60.000 2020-01-06T17:...
Ole Tange's user avatar
  • 4,789
0 votes
0 answers
30 views

Why is the Date column sometimes the Date Taken column, but 12 hours ahead?

In an effort to find an answer to my other question, I came across this unusual behavior. Sometimes the Date column is a copy of the Date Taken column, down to the minute, but exactly 12 hours ahead. ...
LCIII's user avatar
  • 374
0 votes
1 answer
3k views

How to bulk rename files in a directory using the Date column

I've got a list of a few hundred files that I need renamed by appending a modified version of the Date column to the front of the file name. The tricky part is the use of the Date column. I've tried ...
LCIII's user avatar
  • 374
1 vote
1 answer
302 views

Date format to string in ddmmyyyy

So I am working on an existing workbook so I cannot change the layout unfortunately. In the first sheet, a function automatically returns today's date in the "yyyymmdd" format. On another sheet, that ...
TomBird's user avatar
  • 174
3 votes
2 answers
14k views

How can I place a date in dd/mm/yyyy format into an Excel cell with VBA?

I want to fill a cell in a worksheet with the date as string and I want it to be in the dd/mm/yyyy format. I use the following code but it keeps showing as mm/dd/yyyy. I'm not sure what I am doing ...
TomBird's user avatar
  • 174
0 votes
1 answer
174 views

How should this datetime format be interpreted? "20190328012019.000000+120"

20190328012019.000000+120 That's the weird timestamp outputted by WMIC commands on Windows. I assume that 2019 is the year, 03 is the month and 28 is the day, and that 01 is the hour, 20 the minute ...
Clancey Nageotte's user avatar
0 votes
1 answer
51 views

How to include more dates on my x axis

I’m having issue to include additional dates on my x axis. Usually I’d select data, edit my horizontal axis label to include more dates. (2nd pic) But it’s not showing up on my graph. (1st pic) I also ...
rachel joo's user avatar
1 vote
1 answer
3k views

Excel not properly comparing dates, despite same cell format

I have two date rows. Both are formatted as dates. When I do a logic test to see whether the two dates, excel is not recognizing them as the same. Here is a screenshot of the cells: This is to ...
Merv Merzoug's user avatar
0 votes
1 answer
414 views

command date not respecting timezone

I'm in git-bash on Windows 10 : ~$ locale LANG=C LC_CTYPE="C" LC_NUMERIC="C" LC_TIME="C" LC_COLLATE="C" LC_MONETARY="C" LC_MESSAGES="C" LC_ALL= ~$ date --version date (GNU coreutils)...
Philippe's user avatar
  • 125
1 vote
1 answer
39 views

Excel count numbers, with taking day of today in account

I have an Excel sheet that looks like this: In the column "Total" I have the total amount of minutes that need to be executed. In the days after the "Todo" column I have the number of minutes that ...
nielsv's user avatar
  • 115
0 votes
0 answers
193 views

Date command not working properly for America/Bogota timezone

On RHEL 7.2 I have set the timezone to "America/Bogota (COT)" With that, if I execute date command it works fine, But if I try to get the UTC timestamp for given timestamp where the timezone is Bogota ...
user2064119's user avatar
11 votes
2 answers
21k views

Is there any way to view dates of changes to Windows registry keys/values?

Is there any sort of date tracking that is done or viewable in the Windows registry, such as seeing the date when X key was created, or Y key was modified, similar to how file systems track? I'm ...
Coldblackice's user avatar
  • 5,884
0 votes
1 answer
239 views

Counting the occurence of active durations by month and into a graph

Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships. Date Started Date Ended Member Name 11/27/2019 12/19/2019 ...
Chris Tam's user avatar
0 votes
2 answers
2k views

How to add fractional year to date in Excel?

Is there a way to add a fractional year to a date in Excel? I have tried something like =date(2000 + 1.2, 1, 1) but the result is 1/1/2001 rather than the expected approximate of 3/14/2001.
Acroyear's user avatar
  • 101
0 votes
0 answers
321 views

Windows 10 - "Sort by Date" but with files on top?

I've noticed that for some reason, anything I unzip uses some other Modified by Date that is far older than when the folder was unzipped on my PC, that makes it very annoying to go through my files. ...
AnoneAnone's user avatar
0 votes
1 answer
404 views

How to autogenerate a date in a libre calc

I think this is easy but I am not finding solutions online. I have recurring bills and would simply like date values to change every month in their respective cells. For example if cell A2 due date ...
Perry_M's user avatar
  • 13
2 votes
1 answer
1k views

Calculate Gregorian Julian Date from Regular Date in Excel

I am trying to get a Julian Date from a regular date (mm/dd/yyyy) in Excel. There seems to be two kinds of Julian date calculation. One is described Here.. The other is somehow related to Gregorian ...
DigitalNomad's user avatar
  • 1,688
0 votes
1 answer
131 views

Date math not giving expected result

I've seen several examples (including this post) and it seems simple enough but I don't quite get what I'm doing wrong (I know that post is for linux but I tried w/ the date command on a linux machine ...
sedavidw's user avatar
  • 101
0 votes
1 answer
726 views

set date +90 days in bash script

I have a bash script to get days from AD since password was created. I need it to tell me the expiration date, which is last set date + 90 days #!/bin/bash pass="$(ldapsearch -Y GSSAPI -Q -H ldap:///...
eekfonky's user avatar
  • 165
1 vote
0 answers
60 views

Received PDF “scan” of alleged e-mail with Sent time later than Received? Fake?

I recently received a bulk PDF file version of important legal documents / correspondence etc. required for court case. I've found a number of suspicious looking, possibly altered docs, etc. After a ...
DocDetective's user avatar
1 vote
2 answers
729 views

Debian 9 vs Debian 10 different date output, the same locale, the same timezone

Could you please advise what is the reason of this difference? How can I change the output of Debian 10 to display 24 hours format with date command (with no additional parameters). Debian 9 date ...
Liam Packton's user avatar
1 vote
2 answers
864 views

GNU/Linux Date Command Ordinal Suffix

The PHP date function offers the ability to add an ordinal suffix for the day of the month, such as 'st', 'nd', 'rd', etc. Is it possible to achieve the same thing with the date command in Linux?
sebshady's user avatar
1 vote
2 answers
743 views

How to convert start/end date to week duration in Excel?

I was wondiring how to convert Start Date and End Date to week duration assuming that the results are always prime numbers? For example:
Loizos Vasileiou's user avatar
2 votes
1 answer
149 views

Excel default date when dd/mm entered

In Excel when i enter a date into a blank cell (General format) as, say 7/15, the cell changes it's format to "Custom: m-ddd". How can i make doing this default to the standard default date "*3/14/12"...
Bill L's user avatar
  • 21
4 votes
2 answers
13k views

Are Excel table headers always converted to text?

I am trying to get table headers containing dates to auto-fill properly, so that they increase by one day between columns. Unfortunately, Excel seems to treat table headers as text regardless of the ...
Mr Ethernet's user avatar
  • 4,311
2 votes
1 answer
493 views

I know how to fix Excel dates stored as text, but *why* does it happen?

The question of how to handle dates stored as text in Excel is common, and so are the answers. But can anyone explain why it happens -- and in particular, whose "fault" is it? I use a tool that can ...
tkp's user avatar
  • 444
1 vote
1 answer
6k views

phpmyadmin Default transformations for DateFormat does not change date format

I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. I wanted to change the default format yyyy-mm-dd to dd-mm-yyyy. Based on my research I can do this using "...
Ali Ahmad's user avatar
5 votes
4 answers
2k views

No solution for Thunderbird date format

I run Linux Mint 19.2 and Thunderbird 60.8.0 (July 2019). I am trying to change the UI to display the dates in a reasonable date format called ISO 8601, and for that I tried setting LC_TIME=en_DK.UTF-...
astrojuanlu's user avatar
0 votes
1 answer
1k views

Excel formula to calculate date based on 2 cells and how to copy to other cells?

Novice excel user here. Here is a simplified version of my spreadsheet: start date end date eday duration -21 4 12 0 begindate = "03/...
user11886696's user avatar
0 votes
0 answers
28 views

Macro is not effective with Date Format Column?

I have written this macro to UNDO any Filters Before saving the spreadsheet. Here is my code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If ActiveSheet.FilterMode ...
WhiteRose's user avatar
0 votes
2 answers
753 views

convert Date to Julian day in Excel

How to calculate the fourth column based on the first three columns in Excel? Date cell to Julian day for example: year month day **Julian day** 2000 1 1 1 2000 1 2 ...
ali's user avatar
  • 3
0 votes
1 answer
355 views

Excel Date calculation

I need to calculate prorated days for real estate closings automatically for the tax prorations. I have everything figured out except I have to manually enter the prorated date. For example, house ...
Severin's user avatar
1 vote
1 answer
369 views

Why does time spontaneously change in debian?

Debian 8. Host system, no virtualization. Time synchronization systems are disabled. ntp, rdate, sdwdate are not installed. # timedatectl Local time: Thu 2019-08-22 14:02:05 +03 Universal time: Thu ...
chaturanga's user avatar
0 votes
1 answer
579 views

converting time in excel and/or adding +12 hours

I have this time in excel 2019-08-04T06:48:45.000Z It is in GMT time, how do I convert it to +12 hours? So what I want is 2019-08-04T18:48:45.000Z. That's an easier one(just have to change the hour) ...
HattrickNZ's user avatar
1 vote
1 answer
123 views

Date formatting only available as root

I have a really weird behavior on both my RaspberryPi 3 and OrangePi 3 after upgrading them to Debian 10. The date command works but I can't set my own formatting with a non-elevated user: baprx@...
BapRx's user avatar
  • 11
0 votes
1 answer
40 views

How to convert dates by working backwards from end of month?

I'd like to convert dates to weeks of month, but I'd like the weeks to be counted back to front, kind of. So if there are 5 weeks in a month, I'd like the last 7 days to be week 5, last 8 to 14 days ...
sonic99's user avatar
  • 51
1 vote
1 answer
630 views

MS Excel - How to model my data in order to produce a chart broken down into product and month (year on year)?

I have one single date column in my raw data. The dates range across 2018 and 2018. I have multiple products and each row represents a sale transaction. There are multiple transactions per product. ...
sonic99's user avatar
  • 51
0 votes
2 answers
96 views

How to manipulate dates?

How can I change a date in an Excel file to eliminate the day and be left with only the month and year?  E.g., convert 4/4/2019 to April-2019? I am aware that I can change the format, but if I do so, ...
sonic99's user avatar
  • 51
1 vote
0 answers
34 views

ntp + ntp loose synchronize each time in 5:00 morning

we have a very strange behavior we have 12 Linux redhat machines - redhat 7.x two of these VM servers are loosing the time synchronize each day at 5:00 in the morning after we restart the chronyd , ...
King David's user avatar
0 votes
1 answer
29 views

Debian GNU\Linux Time Differences

i'm trying to find out why my linux have this difference in times: cmd1: date out1: Sun 14 Jul 2019 12:45:59 AM CDT cmd2: hwclock out2: 2019-07-14 00:46:48.389904-04:00 cmd3: timedatectl out3: ...
Julio C. Pompa Puente's user avatar

1 2
3
4 5
11