Stack Overflow
Stack Overflow

Questions tagged [excel-dates]

37 questions
2
votes
1 answer

Persisting the date format in excel while fetching data

We have a excel add in built using office.js. Where we read data from a data range ( ie A1:C10 ) which might consist of a date column. Please refer the image below Our add in reads the data and form a CSV dataset which is downloaded when the user…
naveen ashok
  • 311
  • 1
  • 16
2
votes
1 answer

Query between two dates from excel using c#, but the problem is I am getting the wrong dates as the result

Below is my code. I get my dates from two DatePickers in a Windows Form. I am trying to get the rows in Excel that are in between those two dates and do a SqlBulkCopy to SQL Server. I am getting the wrong dates as a result. I have tried using a…
Srivaishnav Gandhe
  • 139
  • 8
2
votes
1 answer

How to convert in modern C++ a double into a datetime

How to convert in modern C++ (C++11/14/17) a double into a date time using the date.h library, when the double has been generated while exporting an Excel worksheet as a CSV file? For instance, the datetime appearing in Excel: 21/08/2017 11:54 has…
stegua
  • 211
  • 5
  • 10
1
vote
2 answers

Excel: Formatting text into a recognisable date

I have a .csv file with many rows where the date is formatted as you see in column A. I manually copied and then changed the date to how I want it to be in column B where it's also recognised by Excel as a date (and not text). My question is does…
Reck
  • 81
  • 6
1
vote
0 answers

Excel 365 functions LEN, LEFT and RIGHT, and FIND not yielding correct results

I am trying to separate a date & time stamp (e.g 01/09/2017 00:08:05) in cell C2 of column C in to two columns as Date (01/09/2017)and time (00:08:05). The cell format of the date & time stamp (C2) is Custom (JJJJ"-"MM"-"TT" "hh":"mm":"ss) In cell…
Venkatram Bachoti
  • 11
  • 3
1
vote
1 answer

Create list of custom non-standard date formats in excel

I have a table in excel with non-standard dates written in four general formats (first column), and would like to convert each to a standard excel date format (2nd column). Early 2022 should convert to 01/14/2022 YE 2022 should convert to…
Madisonel
  • 105
  • 9
1
vote
2 answers

automatic static date and time when a value was copied from another worksheet and pasted to a sheet with macro

I am working on a worksheet that will enter static date and time in an excel worksheet when a value is typed in a target cell. However, the worksheet will be used where values are copied from a downloaded file and pasted to the macro worksheet. When…
doubleD
  • 269
  • 1
  • 12
1
vote
1 answer

How to convert number into date-time format in excel ( i have equivalent solution achieved in R)

Referring to the above screenshot, i'm trying to crawl data from Singapore Stock Exchange, which the web content is loaded dynamically from an API call returning json, example here I'm having some problem with the dates, which is given as a number…
Jeremy
  • 379
  • 2
  • 11
1
vote
0 answers

How to use Time format for hour greater than 24?

I need the format hh:mm:ss into my cell, so I use : Cells(i, j).NumberFormat = "hh:mm:ss". This is working fine when number of hours is lower than 24. But for some cells, values are 35:58:00 or 46:12:00. So, Excel replaced 35:58:00 by 01/01/1900 …
Royce
  • 1,557
  • 5
  • 19
  • 44
0
votes
1 answer

Filter Count & Sum Based on Given Criterias

I have an excel workbook with a Database worksheet, this worksheet has a table RecordsTable. The important columns to note are: REG.DATE and CARD The RecordsTable[REG.DATE] are stored as Date month/day/year asin 8/7/2023 and 8/28/2023 and…
DigitalBraine
  • 111
  • 9
0
votes
2 answers

"Handling Format Inconsistencies in Time Variable When Importing Data in R"

I have a dataset in R where a time variable has been imported as text. This is because, not specifying it to be imported as text results in many observations being converted to NAs. However, I've discovered that the time variable has inconsistent…
Darwin Galvis
  • 49
  • 7
0
votes
0 answers

Identify if a date range includes Weekends and/or Holidays in Excel

I'm trying to figure out how to identify if a date range contains weekends or holidays. For example: Name Start Date End Date Check John Aug 22, 2023 Aug 26, 2023 Jane Jul 1, 2023 Jul 8, 2023 Bill Aug 28, 2023 Aug 30, 2023 Bob Sep…
goodnoodle
  • 3
  • 3
0
votes
2 answers

I cannot format "November 9, 2000" date in EXCEL to "09.11.2000"

So I have this data - November 9, 2000 in Excel (the column type is Date). After hours of trying I cannot format it to something like 09.11.2000. I've tried: Column to text transformation Format cells Please help
user2620644
  • 521
  • 1
  • 12
  • 25
0
votes
1 answer

Add date to multiple cells based off another column in Excel

I'm trying to create a Pivot Table from this exported report. Screenshot: However, each line does not have a date on it. I've attempted to create a new column to add the dates to each line, but my formula only works on the first blank line. Any…
Ruth
  • 5
  • 2
0
votes
2 answers

Ensure Excel (Persian) date is valid date with specific format

Problem: We a need a specific column to accept a (Persian) date with specific format (yyyy/mm/dd). Attempts: I've tried to use Data Validation, to a accept specific format: Blocker: The date we're writing is a Persian date in 'yyyy/mm/dd' format,…
Mohamed Mostafa El-Sayyad
  • 257
  • 2
  • 15
1
2 3