Questions tagged [excel-dates]
37 questions
0
votes
1 answer
Formula returning previous month in `mmmm` format, only returns January
I have a worksheet that I use every month and would like a formula that automatically updates to the previous month.
=TEXT(MONTH(TODAY())-1,"mmmm")
always returns January.
However, just MONTH(TODAY())-1 correctly returns 11.
Why then when I…
BruceWayne
- 22,923
- 15
- 65
- 110
0
votes
1 answer
Excel dates are not in Date format
I have extracted data from a SAP application and now I want to uses this data on excel sheet and perform certain action. However, data is time series data and dates are not in dates format.
I see 01/9/2009 in Excel sheet but when I double click that…
Prashant Agrawal
- 37
- 2
- 8
-1
votes
1 answer
how to prevent converting date column to string in excel import
I'm using following code to import excel and read the file
https://www.c-sharpcorner.com/blogs/upload-and-read-excel-file-in-mvc1
while getting data from date column it automatically converted to string.here this column is formatted as date in excel…
devSS
- 39
- 2
- 7
-1
votes
1 answer
Convert SQL date number into date using javascript
Gabriele Petrioli please read my question before you close it.
my reports in SQL are daily, and INT as Date is perfect, two years ago I test Azure CosmosDB and I was able to convert by using JavaScript I did it by using UDF I just needed now for a…
Valentin Petkov
- 1,570
- 18
- 23
-1
votes
2 answers
Convert Excel numeric dates to R dates, but in some rows there is only the year given, e.g. "2018" instead of "43465"
I read in an Excel file with one column containing dates. In some rows there aren't complete dates, but only the year is given, e.g., 2018.
What I obtain in R is
> df$date
[1] NA NA 43465 43465 43465 43465 2018 NA 43465 43465 43465…
user29184
- 45
- 3
-2
votes
1 answer
How to read date from an excel file in JavaScript
How to read date from an excel file in JavaScript ?
When I fetched a date field from excel file, it comes like some integer/floating point number, how to display the original date present in the excel file.
Rahul Sarma
- 763
- 2
- 8
- 17
-2
votes
2 answers
Java date conversion formats
from date format change to this format - 01-Jan-2019 in excel using java.
I want to read the date format in excel. if suppose having any date format want to change DD/MMM/YYYY format. ie., 01-Jan-2019. any one please suggest and help me.
Gn gn
- 1
- 1