All Questions
2,938
questions
0
votes
1
answer
34
views
Excel Formula for Today's Month Being Greater Than Lookup Value Month & Provide Message
I have created a budget sheet in Excel to track Debt Snowball payments. I have a formula that successfully works to lookup the month from a list of months (column F) that a final payment is made for a ...
0
votes
1
answer
48
views
Coding to convert Date from Worksheet to Textbox
I have my dates in worksheet but its appear format as number in textbox, and I'd like to convert them to dates in textbox. Whats code do I input to my userform?
Private Sub TBMOS_Change()
Me.TBMOS....
0
votes
0
answers
62
views
Python Pandas reads inconsistent date formats from Excel files generated automatically with a 3rd part API
I'm using the PDF4me API to convert PDF invoices into Excel files. The dates are read correctly by the API. However, when I open the Excel files, the dates are displayed inconsistently:
Some dates ...
1
vote
0
answers
27
views
Date as number/text in YYYYMMDD format, but Excel won't format? [duplicate]
I'm working with a JSON dataset that presents dates as numbers in a column like so: 20190611, meaning it should be 2019-06-11. What can I do to get Excel to format these dates? Normal formatting doesn'...
0
votes
0
answers
20
views
Convert DD/MM/YYYY to ISO 8601 format in Excel Sheet [duplicate]
I have a list of birthdays in the following format in Excel.
07/06/1987
04/04/1993
14/05/1973
13/07/1969
etc
I would like this to be converted to the format: 1987-06-07T11:31:01.805Z
How can I go ...
0
votes
0
answers
44
views
Getting Real Date and Time in Excel VBA if System time is on Manual [duplicate]
if a User has altered the System Time, the Date and Now functions return the ALTERED time. How to override this and still get the Real System time?
While using this code, I can't use Internet, ...
0
votes
1
answer
34
views
How do I disable any kind of automatic conversion into excel when using xlwings?
When using xlwings, I want to, for example, write the string "4 / 5" into excel. However, if I write.
sheet[0,0].value = "4 / 5"
I get: string converted to date
I do not want to ...
0
votes
0
answers
15
views
Date Object dont recognize a string using XLSX
I'm using XLSX package to read an excel file and for some reason some Date Objects are Date and others are string.
I'm using this line to define cells as Date type.
const workbook = XLSX.read(buff, {...
-1
votes
0
answers
38
views
VBA Excel prevent file from opening after trial has expired
Hello there i am seeking some assistance with my code. I got most of it incorporated. I am trying to create a code when the file is open for the first time on someone's computer that the file ...
0
votes
0
answers
71
views
Extracting records in a range in excel
Hi I have an Excel table with about 7k records.
I want to extract specific records in to a new table that have a date range of >=date1 and <=date2 The main table has a date field
I was trying to ...
0
votes
0
answers
30
views
Excel autofill date when data entered in a nested worksheet
I took this existing code which works fine in a single sheet to update the date when data is entered in adjacent cell E it updates with the new date in Col D, and it updates daily in a test sheet when ...
0
votes
5
answers
165
views
Calculate days of each month in a range date in Excel Formula
I have sets of date range that I need to calculate total number of days. but usually the start of the range and the end is during the middle of the month.
So how do I calculate number of days of each ...
-1
votes
1
answer
16
views
Display issues in cells when splitting date/time into multiple columns
When using the =right formula to split the date and time so that just the time displays in a separate column, the values didn't always display correctly. First the values came into the new column as ...
1
vote
1
answer
52
views
Read Date from excel and insert into PostgreSQL
I have problem while reading date from Excel file using Apache Poi.
I use the following:
FileInputStream inputStream = new FileInputStream(excelFilePath);
Workbook workbook = new XSSFWorkbook(...
3
votes
4
answers
123
views
VBA - Calculate exact difference between dates (edge cases)
I tried to search Stackoverflow but didn't find a solution for me.
I need to improve the days and months calculation logic, ensuring accurate adjustment when crossing month boundaries. I assume ...