fri

  1. G

    Index, Match when values the same

    I'm trying to setup a roster. In Cell K1 I have the date (which changes through drop down box). In column A I have a list of dates which some are the same date, Column C has Team 1 and Column E has Team 2 What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in...
  2. A

    Does A Variation Of A Filename Exist In A Directory

    I have this code: Sub cheese() Stop sdate = 43609 'May 24 2019 EDate = 43757 'Oct 20 2019 Days = 148 For lp = sdate To EDate t_mon = Format(lp, "mmm") t_day = Day(lp) t_dayy = Format(lp, "ddd") tar_str = t_mon & "-" & t_day & " (" & t_dayy &...
  3. smide

    Convert date to weekday name

    Hello. In column A (A1:A600) I have dates and time in format dd.mm.yyyy - hh:mm (ex. 04.10.2019 - 20:00 , there is one space between dd.mm.yyyy and '-' and one space between '-' and hh:mm). All those cells in column A are text cells. I need formula to convert those "dates" into weekday name...
  4. R

    Question regarding counting non-blank cells.

    Good day all, this is my first post here. I have a table of information that I edit each day, needing to have the newest information on the top of the list. I need to do a count of non-blank cells in column A, and as I append the list, I add a blank row at the top of the list. Well, I actually...
  5. L

    number based on the value of another column.

    Hi I have a column like the one below. I want to have another column beside it and each friday in column A will have number in column B as below. Is that possible to do it? Thank you very much. <colgroup><col></colgroup><tbody> Tue, 20/08/19 Wed, 21/08/19 Thu, 22/08/19 Fri, 23/08/19...
  6. B

    Understanding how a formula works

    Hello all, I am confused with how the formula below works. What part of this formula makes the date know it's 2019? The result I am getting in B1 is Fri, 01/04/19 :confused::confused::confused::confused: Cell E3 - 1ST FRI EVERY JAN Cell F3 -...
  7. D

    Getting the SUM of a range of cells with formulas

    I need a way to have a cell be NULL if it is Sat or Sun I did find a formula to do this, but then it won't SUM the row and/or column <tbody> Site US1787377 Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Monthly...
  8. P

    Using Lookup & Conditional Formating

    Hi, I have 2 worksheets - Course Entry worksheet and Training Room Schedule worksheet. For Course Entry worksheet, user updates data such as course title, duration, training room, etc. As for the Training Room Schedule, it shows a list of training rooms in a monthly calendar view. Once user...
  9. N

    Returnign largst or smallest value from a subset of values

    Hi there Am hoping someone could point me in the right direction with a quick one. I have a list as below, and am looking to return the smallest or largest value by day: A B Mon 154 Tue 192 Wed 216 Thu 147 Fri 126 Sat 98 Sun 48 Mon 52 Tue 69 Wed 210 Thu 99 Fri 137 Sat 104 Sun...
  10. B

    Data to appear when between 2 dates - Round 2

    OK, Let's try this again. I hope this makes more sense and look forward to see some responses if this is at all possible. I currently do all of this manually for a project that will be going on over the next 18 months. On the Due Day in column B, I would like to see the quantities in column A...
  11. C

    Find, maybe

    I need to look up the sup total or Over time based on the name. Example i want to put Doe, John in a cell and have it bring me 0.77, any ideas? <colgroup><col><col span="4"><col><col><col span="3"><col><col span="3"><col><col span="2"><col></colgroup><tbody> Pay Date Pay Code...
  12. E

    On-Call Schedule: Table Needs to Show Dates

    First of all I want to thank MrExcel.com for everything you guys do, I have been able to find plenty of answers to many questions I’ve had in the past. Well let’s get into this conundrum, in short this is an On-Call Schedule, what I’m trying to accomplish is to for the techs to select their...
  13. K

    Yearly attendance

    <tbody> 2018 CFL's 2018 balance 2019 balance <tbody> 8-Feb-2019 2018 CFL's 2018 balance 2019 balance Jan-19 Feb-19 1-Jan-19 2-Jan-19 3-Jan-19 4-Jan-19 5-Jan-19 6-Jan-19 7-Jan-19 8-Jan-19 9-Jan-19 ID Name P L A C T CL P L A C T CL Tue Wed Thu Fri Sat...
  14. C

    Sumifs with range

    Hello! I am trying to find the total of column's C, D and E if column A falls in a specific range. I figured out how to get the total files if A is >=10 and >=23 but I can not get the total files if A is 11-22. ~ Thank you in advance for your help! <colgroup><col width="21" style="width...
  15. R

    Date formatting

    Hi I have a list of dates as follows... Fri 01-Jun-18 Fri 29-Jun-18 Wed 01-Aug-18 Fri 31-Aug-18 Mon 01-Oct-18 Thu 01-Nov-18 These are actual paydays associated with the nominal payday of "first the month". ( If the 1st falls on a weekend you get paid on the previous Friday) Is there a way of...
  16. A

    Create Calendar automatically

    Hello, I'm hoping that someone can help if possible please. I have created a tracker for tasks performed across our department. Each month has 5 rows (but this can increase depending on how many tasks come in) and the days are listed across in the columns. Each year, we have to re-set the...
  17. A

    formula to calculate based on date

    Hi, I am trying to veryify my power bill and have raw meter readings showing kwh consumed in every half hour interval Is there a formula I can use to calculate the price I should be charged per half hour block? I am on time of use so i get charged as follows between 7am and 1pm mon - fri -...
  18. J

    Calculate TY/LY comp by aggregate daily sales

    I am trying to calculate a live sales comp for 2017/2018. In order to do the basic comp calculation, I need to sum 2017 sales up to the last corresponding sales input line for 2018. In this example it would be 2000. If I entered sales for 6/4/2018, the new aggregate sum for 2017 would be...
  19. C

    Edit Existing VBA to subtract .5 for lunch each if total hours are 6.5 or greater each day

    We purchased a time clock, and the time clock company supplied us with a macro that total the daily hours as well as the total hours for any date range that we choose. Our company policy is if an employee works 6.5 or more hours per day, we subtract .5 hours from that days hours for lunch. I...
  20. U

    Place a number in a calendar like spreadsheet, that places a number every second thursday

    A B C <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Date Thu 05 Apr Fri 06 Apr Sat 07 Apr Sun 08 Apr Mon 09 Apr Tue 10 Apr Wed 11 Apr Thu 12 Apr Fri 13 Apr Sat 14 Apr Sun 15 Apr...

Some videos you may like

This Week's Hot Topics

Top