weekday formula

  1. T

    Auto Week 1 to Week 5 with date

    I have a report for weekly review to my candidate. I count each week from Mon to Sun as 1 week. so if one week have only 2 or 3 days, then it will leave blank. please find the sample here Sample i do try the formular such as weekday but it is really complicated that i start to lose myself when...
  2. D

    Another nth day fill question, show every Tuesday in a month accounting for Feb

    once again I am here for help, I've read hundreds of tutorials on how to fill dates, get every 1st and 3rd day, every Monday ect ect.. but none of them seem to account for the 28 or 29 days in February.. In my sheets, the month is pulled from the sheet name, then converted to a number, the year...
  3. 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...
  4. 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...
  5. 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...
  6. 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?
  7. R

    Nested IF Function Regarding Dates

    Hi All...
  8. 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,
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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!
  14. 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...
  15. 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...
  16. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back