weekday formula

  1. M

    i need formula for dates

    Experts, I am attempting to make a payroll calendar and paycheck distribution date. I have the start date in A1 and to make my bi-monthly dates, A2 has the formula =IF(DAY(A1)<15,DATE(YEAR(A1),MONTH(A1),15),DATE(YEAR(A1),MONTH(A1)+1,0)) I am trying to place a formula in A3 that would calculate...
  2. S

    Average if Error

    Hello, Why am i getting #DIV/0! ??? =AVERAGEIFS($C$3:$C$40929,$B$3:$B$40929,$E3,$D$3:$D$40929,F$2) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> 1 A B C D E F G H I J K L 2 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Date...
  3. E

    Date patterns (How to enter dates for every Wednesday and Friday)

    I need a formula, way to input the dates of every Wednesday and Friday since 01/07/2105 so for example the dates I require int he pattern would be: 01.07.15 03.07.15 08.07.15 10.07.15 15.07.15 17.07.15 and so on - every Wednesday and Friday. Rather than typing out the actual date is...
  4. D

    Difference Between Weekday Only, Not Including Weeked

    Hello All! I am looking for a way to count the difference in days between a PickUp (PU) date and the Delivery (Del) date of a shipment. For example, if PU date is 3/3/14 and the Del date is 3/12/14 I would like a formula to tell me how many weekdays are within this range. Can anyone help?
  5. R

    Nested IF Function Regarding Dates

    Hi All...
  6. U

    Is there a way to create a Data Validation dropdown list of the next 52 Fridays?

    We have weekend projects that start on Fridays and I know I can create a list on a separate worksheet but I would like to avoid this. I think I need a Data Validation formula using WEEKDAY in it. Thanks,
  7. A

    Help with Weekday Formula

    I have a form that has dates that need to be populated based on a numerical code placed into cell H46. I have the number of days for the 13 codes listed on another tab called Dates. The formula I'm currently using takes weekends into consideration and I only want the dates to count weekdays...
  8. TAPS_MikeDion

    Quick Day of the Week Question

    Hi guy's, Apparently, I have jello for brains at this point, because this seems so simple. Anyway, I have the following formula in cell K14 and want another cell to display the day of the week based on this cell. Cell K14: =TEXT(TODAY()+1,"mmmmmm-dd-yyyy") For some reason, using the...
  9. M

    Changing any Weekday to a Specific Weekday

    Here's my problem: I'm looking for a formula to change a weekday in the previous month - the day that is 30 days from a day in this month - to a Monday of the following week, if it's a weekday oother than a Monday. For example, if 30 days from the current month (June) is May 24, 2012...
  10. X

    weekday loop macro

    Hi, i have a bunch of dates in column B that are populated from an external feed into excel. the dates are populated starting at cell B5 and going down X number of rows...X because the dates could go down 5 rows or 50 depending on what the external feed populates into excel, but never over 200...
  11. T

    Week Number

    I am trying to make a column for week numbers that either needs to start on thursday or end on thursday, right now i have =WEEKNUM(A4,2) and i think i need to change the 2 but im not sure really appreciate the help!
  12. L

    Add weekend days to the total amount

    Hi all, I making some planning for my company and they make all the calculations as a working days. I need something like this: Cell A=Starting date Cell B= End date Cell C= Number of working days I want that cell B get calculated starting from A and adding C and the corresponding weekend...
  13. G

    WEEKDAY function does not work in all regions

    Hey, has anyone ever noticed that the WEEKDAY function returns #Value if your region in the Control Panel is set to Hungarian or Chinese (or possibly others)? I have written some worksheets that are being used globally and discovered this problem when some users in these locations said the...
  14. B

    Subtract Saturday, Sunday, & Monday

    In Microsoft Excel, I would like to subtract Saturday, Sunday, & Monday from the days of the week and still have the formula give me a calculated day. Right now I have a WEEKDAY formula that calculates 29 days subtracted from a final date (i.e. January 22, 2010 - 29 --> final answer Dec 15...

Some videos you may like

This Week's Hot Topics