Stack Overflow
Stack Overflow

Questions tagged [excel-dates]

37 questions
0
votes
2 answers

Is there any function in excel to find day time between two date and time in Excel?

I need a formula to calculate between two date and time excluding lunch time, holidays, weekend and between 09:00 and 18:00 work hours. For example, 25/07/2022 12:00 and 29/07/2022 10:00 and answer has to be 1 day, 06:00 Thanks in advance. I had a…
efsane99
  • 1
0
votes
0 answers

How to make flow run successfully when updating blank/empty "Date" column from Excel Table to Sharepoint List "Date" column with our error?

I created an automate flow to convert Excel table to SP List. In Excel Table it includes "Date" column which could be blank/empty. And this has caused flow error when updating "Date" column in SP List. My flow structure as attached Automate flow
user19348627
  • 1
  • 1
0
votes
1 answer

Wrong date time format when insert date from PowerApps into Sharepoint list

I have a Powerapps app to allow user to select a date with dd-mm-yyyy format and direct insert it into Sharepoint list with same format (no time). It works normal but some records from users could insert date with time in Sharepoint List. It shows…
ahmug
  • 1
  • 4
0
votes
1 answer

Excel formula to determine shipping date

Due to production and shipping issues my job has created a report that has the customer's need by date and if a product has been completed or not. If an order is complete we need to determine when it will ship out and arrive to the customer. We have…
Esme.Ivy
  • 1
0
votes
1 answer

How do I automatically create and update month date list in excel?

I would all the dates of the current month to be listed in a column, updated to the next month on the 1st of the month, and no requirement for me to input anything into the system. I've played around with multiple IF functions and different date…
PhilosophizerMD
  • 15
  • 3
0
votes
0 answers

Excel formula not working in a table but works in a range

I have a very basic excel formula which works in a range but when I bring the data into a table the formula does not provide the correct results. the formula is =MAX([@[sub_date]]:[@[sup_date]]) when this data is in a range the formula is…
Ross
  • 69
  • 8
0
votes
1 answer

logics for particular dates for overtime sheets in excel

I am working on overtime sheet for a institution. I made a sheet where I used date from 1 to 31 of days. However, over time is appearing in random days. Therefore, I need to write this days manually. Thus, I want to apply logics if input OT into the…
Turjoy Ahmed
  • 29
  • 9
0
votes
2 answers

Formatting date in Excel

How can I easily format "202104" --> 2021/04 in Excel? My current method is to concatenate the original string with "01" and then change it into a date. However, I am seeking a more efficient format method. Thanks
Qwerty
  • 27
  • 3
0
votes
2 answers

Date incorrectly converts into required format (dd/mm/yy) in excel

Hi I know lots of similar questions can be found here, but I am still facing this problem: I have a table with one column called Dates with some values shown…
user11505060
0
votes
0 answers

usa date format to europe

i have problem, that this macro is searching date with format mm/dd/yyyy and i need this format dd/mm/yyyy. Please help me to fix it There is my code n = Format(Date, "dd/mm/yyyy") If Weekday(Now()) = vbMonday Then …
Salim
  • 11
  • 1
  • 5
0
votes
0 answers

Excel: When a user on another computer enters the date into a cell, format converts to string

I've never had this error before and I can't find anything about it on google. Basically, I have a workbook with an "instructions" page that has some macro buttons and a cell to enter a specific date. This cell is date-type, not string-type. I have…
las
  • 17
  • 5
0
votes
0 answers

Reading a Data cell value from excel

I am reading an excel file and am trying to find out which of the cell values are date values. Now, I tried doing it with getCellType of Apache POI SS User Model but the problem is my excel is returning String value even for the cells which contains…
MitSM
  • 21
  • 11
0
votes
2 answers

String to date conversion with Excel VBA

have a string datetime that contains a pending 'AEST' that needs to be removed so can do date calculations to do this manually using Find and Replace 'AEST' with blank works. However want to do this in VBA which does not work. - for example when…
da3data
  • 13
  • 3
0
votes
1 answer

Convert from Excel datetime to ZonedDateTime

A datetime in Excel is saved as the number of days since 1900-01-01 (+1 as it thinks 1900-02-29 occurred). The fraction in the number is the time offset in the day. This number has no concept of timezones. So 12.5 is 1900-01-12T12:00:00 in the…
David Thielen
  • 28,723
  • 34
  • 119
  • 193
0
votes
1 answer

Convert Excel custom date column in vb6

I have a vb6 code that read value from excel which is in mm-yy format . I want to convert it as dd-mm-yyyy format in my application My vb6 code for reading column is .Range(Purchase_Excel!ExpdateColumn & intLoopCounter) where counter is the row…
MANOJ AP
  • 56
  • 5
1
2
3