I need to get the maximum DAY dates of the following clients
Client Max day dates
Here is the source data:
CLIENT CATEGORY DATE RECEIVED
A MEDICAL 7-NOV-19
A DENTAL 15-NOV-19
I need to get the deadline of the following client:
The source data looks like this:
Deadline 10th-15th 16th-20th 21st-25th
Blank ClientA ClientB ClientC
Blank ClientD blank ClientE
I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ?
Hi, I have a list of weekly dates in Column A and Costs in Column C. I am trying to find the lowest value of C if the date is before this week (as the values constantly go up, using min gives a misleading result as every week starts at £0.
My formula (array) is as follows:
I have two dates, where I'd like a message box to pop, if the dates are between this criteria.
sDate1 = #10/1/2019#
sDate2 = #9/30/2020#
How would I create the following?
If date is between sDate1 & sDate2 Then...
I have software that exports date data to a workbook. I am expected to utilize this data to feed another report. The issue is all of the dates are exported into text, I have to update this weekly sometimes ad hoc when requested. I was wondering if I could modify my macro to somehow get around...
Hello Folks ,
I am working on a file where in i am setting control limits "Upper Control Limit" and "Lower Control Limit" Sheet is working fine for me however need a small logic to be build in the below formula .
In the above Formula "C24:C523 is the range...
I appreciate if somebody please help me with how it's better to clear contents but preserve formatting.
I have a data with dates and numbers. When I use Sheet.Range ("A2").CurrentRegion.Delete this preserves formatting for numbers but does not preserve for dates.
When I use Sheet.Range...
I have a UserForm where the user must update the Public Holidays (South African) for the year. Basically the user must only change the year and then the date of Easter Friday. All the other dates will auto update in the relevant Table ("tblPPH") In this UserForm, there will be a...
I'm calculating number of months and days in between 2 dates (jan1 2019 & Dec 31, 2019) using a formula Value(Datedif(A1,B1,"M")&"."&datedif(a1,b1,"md")+1) and i am getting a result of 11.31 but i wanted to appear as 12 instead (since 31 completes the whole month).
I want to get the real...
I have a column of both future and past dates. I would like to create another column that groups the dates into summary classes (ie. Overdue, Due in 7 Days, Due Between 8 - 30 Days, Due Between 31 - 90 Days, Due 91 - 365 Days). Is there a formula that can do this?
Im using this code to color an specific row, from the starting column to the end column for a 4 weeks timeline graphic (not a grant chart) but since I'm using dates as headers the columns are not corresponding with the dates
can you please help me to find the column number (StartColumn) based...
I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...
I thought this would be simple but my attempts are not working for me. I need two things PLEASE.
I am trying to calculate the total number of "days" between two dates, and secondly, calculate the number of "week days" between the same dates. Each would be in a separate cell. I am totally...
I am trying to take data with random dates 9/5, 9/12, 9/19, 9/26 on the X axis and graph them and when I do the axis with the dates is reading all dates in between is there a way to only have the dates specified show up on the graph rather then all dates in between?
I am trying to solve a problem I am have trying to add the days of shifts for multiple people but running into a issue it will correctly workout the number of shifts excluding dates that are the same but I need it read a repeating date if that person name is different.
I have all this...
I have a strange behaviour occurring whilst trying to load a Listbox on a Userform.
I have the following code which populates the Listbox with data dependant on the value of column E:
Private Sub UserForm_Initialize()Dim Rng As Range, Dn As Range, c As Long, Ray()
Set Rng = Range(Range("A2")...
I have exported a file as a CSV that includes dates and other information. Upon export, the dates are not in chronological order and I cannot seem to get them sorted into chronological order. I don't know what I am doing wrong. I also do believe that the dates are stored as text but can't...