# weekday formula

1. ### 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...
2. ### 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...
3. ### 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...
4. ### 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...
5. ### 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?

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

### This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

### 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.

### Which adblocker are you using?

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

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