date & time

I've a column D (which I plan to hide later) either filled with a date or left blank. Then I want to have column E either display the date from Column D if the date is within one year or display nothing if the date is over one year old. The format I have right now in D2 is...

I have two date. I want to count number of days between. Dim date_today, test_date As Date Dim result as Long date_today = Format(Now(), "dd/mm/yyyy") test_date = Format(wsM.Range("M10").Value, "dd/mm/yyyy") result= DateDiff("D", date_today, test_date) But the result is wrong, it's 539...

OK, I've struggled with this for most of today so any help would be gratly appreciated.... I have data for each HH of the week arranged as follows: Sun 00:30 Sun 01:00 sun 01:30 etc to sat Below this I have Seperate day opening / closing hours: Monday 11am - 11pm Tuesday 11am - 2am etc...

Hello all, I have a lot of data with three input columns (End date, Break Date, Rent review) and I can't work out a formula for the output column (LEASE EVENT). In each row, i want to know the closest date FROM today date, with the corresponding column heading to end up in the output column...

I want to auto fill this date sequence: 1/1/17 1/1/17 1/1/17 1/1/17 1/1/17 1/1/17 1/1/17 1/1/17 1/1/17 1/2/17... Basically, repeat the date X times, then move to the next date. I cannot for the life of me figure this out. It can't be that hard?!

Hey guys! I'm doing some time analysis and I was hoping someone could offer some help. Basically, I've broken down my days into several different categories and I'd like to summarize the total of each category for each day. Kind of hard to explain, see my example for clarification :) Thank you...

so if there is a date that is defined in range a1 that is within 48hrs then the macro wont run? and offers a MsgBox instead? many thanks jamie

Hi all. I hope you can help. I have inherited an excel sheet with a formula that I don't fully understand. Essentially I believe the formula is looking to determine the amount of time a task from creation date and time (Cell U2) took to complete from (Cell V2) both in hours and minutes. This is...

Hello, I'm looking for a way to convert a text string into a format that Excel recognizes as date+time. Excel version used is 14.0.7177.5000 (32 bit) Italian localization, part of Office 2010 My source text format is like this inside a...

Hello everyone, My first post here, I've searched the forums extensively for a past week but couldn't find exactly what I'm working on. Unfortunately my case has some weird details . I'd like to ask you for help as I'm stuck right now. Here's the table showing what I mean: <tbody> start...

Hi all, I have been trying to generate interest calculation automatically for my business. For example if we take one client at a time my business norms is if the balance is unpaid for 10 days then interest is applicable from the date of purchase. II have entered the formula for this and it is...

Hi, I wanted to create an excel form that has a drop down menu in column A and time stamps in columns B to E (four). I wanted the time stamps to be entered for each column whenever the Column A' cell has been changed from the Drop down menu - which is Step 1, step 2 Step 3 and step 4. I wanted...

Hi, I have the text strings in the following format in my excel sheet: joey/ Date 08-17/2016/ the quick brown fox/On 2014-12-03, "ABC" debses/Asset category: Equity/balanced.- Now, I want to extract the second date i.e. 2014-12-03 in a separate column from the string above. Could someone...

Hi, I want the default value of my input box to reference a cell. This cell is also the destination for the data inputted in the input box. I'm running into some issues with the value posted back to the cell.. let me explain exactly In C2 I have the date 01/04/2016. When I run Sub EnterDate()...

I have data and need to check Date and Time. then check in list if i get this Data "6/21/2016 11:50 5I" i check 1 in "6/22/2016" Below pic i use sumproduct check time and date and before 11:00 or check time and date-1 and after 11:00 Sorry about my English have other way to calculate...

Hi Guys, I was just wondering if anyone has the VBA syntax for counting days. in C21 I have 01/01/2016 in D21 I have 11/01/2016. If possible I would like the total amount of days shown in B21 any help would be greatly appreciated many thanks and all the best bloodmilksky

Hello, I have a question on a chart that I am trying to build in excel. My goal is to find out if production on a machine is " on time to start date compared to the finish date, taking into consideration there is a " set up time and run time ". Columns: L=start date , M=finish date , N= set up...

I am using Microsoft Excel 2011 for Mac. I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date. I have a bunch of dates like this: 2/1/16 3:39 AM...

Hi, I am trying to convert the following 13 digit json number -> 1452002465000 to date/time. I am using this formula ->=D7/1000/86400. This is giving me 03/01/1946/ 12:28 PM. The time is correct but the date is wrong (should be 05/01/2016)

i am trying to create a proposal from information that i gathered about a month ago. I would like to input a formula that shows todays date if information changes in cell M23 but doesnt change every time i reopen the document. i am not going to be physically changing the data in cell M23 it will...