1. X

    Use Formula to Insert Fortnightly Payments in Table

    Hello, This is my first post and I'm hoping to get a bit of help with creating a formula that I can use on a finance table that I've created. I am attempting to forecast my personal finances and want to insert fortnightly payments into a column automatically. I've managed to do this for my...
  2. R

    Date Format Conversion Question

    I regularly download a .csv file which I open in Excel and then save as 97-2004 workbook (.xls). Contained in this .csv file is a column with dates which are formatted as short dates. I can't seem to find a way to convert these to long dates other than changing the format and then manually...
  3. A

    Max dates

    Hi Experts! I need to get the maximum DAY dates of the following clients Client Max day dates A 15 B C Here is the source data: CLIENT CATEGORY DATE RECEIVED A MEDICAL 7-NOV-19 A DENTAL 15-NOV-19 A VISION...
  4. A

    Get the Dates

    Hi Experts! I need to get the deadline of the following client: Client Deadlines A B C D E The source data looks like this: Deadline 10th-15th 16th-20th 21st-25th Blank ClientA ClientB ClientC Blank ClientD blank ClientE What...
  5. R

    Compare Dates in Various Columns

    Hi There, How can I check to see if all rows in columns A, B, and C have the same dates and spot the rows where the dates are different in these columns? Thanks.
  6. S

    How to convert date

    Hi, I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ? 118362 119002 119246 119273 119316 <colgroup><col></colgroup><tbody> </tbody>
  7. P

    Minimum If with dates

    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: <k11,c:c,""))[...
  8. P

    VBA If statement

    Dear All, 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...
  9. S

    Macro for DATEVALUE

    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...
  10. K

    Modification in the formula

    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 . =MOD(COUNTA(C24:C523)-1,K7)+1 In the above Formula "C24:C523 is the range...
  11. A

    VBA clear contents (number and date formats) but keep format

    Hello, 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...
  12. K

    Check if date is Sunday

    Hi Everyone. 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...
  13. M

    Rounding the months and days in between 2 dates

    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...
  14. C

    Summerizing Dates

    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?
  15. R

    VBA code to find colunn number of specific data

    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...
  16. A

    Generating Sign In Sheets from a Master Schedule

    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...
  17. C

    Count Days Between Two Dates

    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...
  18. D

    Charting Data

    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?
  19. L

    Calculate Between two dates

    I need a formula that will calculate two dates Sample In Column K put the number of dates between the Starting Date (I20) and Ending Date (J20), but if I20 or J20 is blank Leave K blank
  20. D

    How to Sum the Frequency of column dependent on another column.

    Hi, 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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...