weekday

Hi, I have a formula that gives me the last Friday of the month, but would like to ensure that holidays are considered in the formula. I have a list of holidays in a table named 'Holidays'. I have tried to add this in to the formula, but have had no luck...

Hi, I am trying to create a function in excel to go "Y" when a date is the last weekday in a calendar quarter and "N" if otherwise, but I am failing miserably :(. In fact I have no idea how to go about it. I had a quick seach through here and didn't find anything. So column A is just a list...

I am using the formula =NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1) where A2 is the start date and B2 is the end date. The NETWORKDAYS function works fine by ignoring the weekend days, however, if the end date is on a weekend then the formula doesn't work, it just gives ########. Is there a way to...

Hi all, I'm very new to VBA and excel development, so please take that into consideration as you read on. I'm trying to create a work form for a database that (should) collect various information in comboboxes, including the date, the weekday, and the month... Note: most of the time, the...

I am trying to average the values of a range of cells based on the day of the week. The spreadsheet is setup as follows: <tbody> Column A: Column B: 1/4/15 23.90% 1/5/15 14.39% 1/6/15 4.62% 1/7/15 5.71% 1/8/15 18.32% 1/9/15 31.62% 1/10/15 11.28% 1/11/15 13.13% 1/12/15...

Hi. I have 2 columns: B & D. B has # events. D has day of the week expressed as a value (2-7 from Mon-Sat respectively). I'd like to copy the values in B over to J20 thru O20 (J-O represent M-Sat as you probably expect) IF they have the same column D value (day #). Conceptually, it's just copy...

Hi, hope you're doing great today. In column B, I have # of events, like this: <tbody> 2 1 1 2 1 4 </tbody> In column C, I have Day number of week, eg: <tbody> 1 (Sun) 2 3 4 (Wed) 5 6 7 (Sat) </tbody> In column D (if you want to use this instead of day number)...

Hi, hope you're doing great today. In column B, I have # of events, like this: <tbody> 2 1 1 2 1 4 </tbody> In column C, I have Day number of week, eg: <tbody> 4 (which is Wed) 5 6 7 1 2 </tbody> In column D, I have (if needed), the actual weekday name (eg TUE, etc)...

I have a list days and clock in and out times. I would like to calculate the total number of hours worked in a work week. The work week begins midnight Sunday and ends at 11:59:59 Saturday. The punch in and out times are in military format. Employees don't work every day of the week. My problems...

Hello Everybody, I went through few posts online about my query but couldnt find anyhting specific. Please help me out I am trying to find a particular text in finite range using macro. I am first finding all the dates in the previous week and putting the values in column B (7 Values - B1:B7)...

Sorry folks, I've searched and searched and spent many hours trying to fathom this one out before posting here, but I need help! I use the WEEKDAY function to return the day of the week (weekending Sunday... so e.g. my formula to return the weekday for a day in cell A1 would...

Outlook allows you to easily specify, but eExcel always treats Sunday as the first day of the week by default. Yes you can manipulate that within formulas and functions, but if you use the autofilter in excel and choose "this week" (or "next week", or "last week") excel considers Sunday as the...

Afternoon, I have a spreadsheet that I am trying to write a macro to sort First by Column B (Date), then by Column A (Day) then by column C (Group). I realise that sorting by date then day may seem redundant, but the date may not always be filled in. My issue is that I can only seem to get the...

Hello, Let's say I am selling a weekly newspaper @ $1 each (retail), and I purchase 10 newspapers at the wholesale price of $0.25 each. During the 7 day week — Wednesday through Tuesday — I sold 8 newspapers, leaving me with 2 leftover papers from that week. So, when the new newspaper comes out...

I am using multiple userforms to gather info. I'm not using any worksheets. I have a command button that creates an outlook task reminder that tells me what I need to close at a set time and date, 3 days from the time it was created, and it work great except I need it to not set any tasks on...

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

Hi Hoping someone will be able to help, I have the below VBA code to filter by date + 2 however on a "Friday" I want this to search for "Tuesday" is there a way that i can code the below to searh for only working days ie Monday to Friday and skip weekends? Sub Filterbydate()...

I'm working on a personal cashflow statement and am stuck on how to write a formula which will allow me to calculate the payment date for each future payment based on the following criteria 1. I know the first payment date - C6 (14-Sep-12 - a Friday) 2. The next payment date will be calculated...

Hi, I'm putting together a cash flow forecast and am trying to work out the payment dates for our invoices based on invoice date + terms (30, 60, 90 etc) + paydate (some are paid on the 1st, some on the 3rd, some every Thursday, and some on the last working day of the month). At the moment some...

Hi, I already have a function which looks at the date and works out what day of the week and by looking at the time of issue, works out if it is between business hours or out of hours. <TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=383...