weekday

I need help with VBA Code or an Excel formula. PURPOSE: I need to auto calculate OT based on the days of the week (Saturday & Sunday). For Monday – Friday any hours as follows: [**This part of the sheet works fine] Cell Range = F15,P15:F50,P50 In Cell Q15 formula: =IF(S15<8,S15,8) In Cell...

Hi everyone, I've been using the code stated below for some time to create a new column for a "due date" which would be 30 days from the chosen input. The problem is that within those 30 days weekends are not being excluded meaning many of the dates are incorrect. Is there a way to integrate...

Hi I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates. The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...

Excel Office 365 I have a pivot table with dates across the top in row 1, names in column A, numbers in the cells below each date for each person. I am looking for a way to provide a sum of the numbers for the dates that are on Friday, Saturday, Sunday while still keeping the other dates and...

Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...

Hello there, I am attempting to create a project planning and management tool for our workplace. What this entails is obtaining "work hours", an "in date", and an "out date" for each project. The program will divide the number of working hours over each business day that a project may be worked...

I am trying to conditionally format a cell that contains a formula based on the day of the week that it currently is and the value that the formula is outputing. I want the cell to be highlighted if the curent day is Tuesday and the value is > 14.9 , Wednesday and the value is >29.9 , Thursday...

Hi All, I've looked through Google and this forum but can't find an answer to this specific issue. Apologies if it was out there and I missed it. I'm not an expert by any means, my formulas may look convoluted. I have columns like these where they highlight to different colors based on dates...

Hello, I'm currently creating a metrics tracking sheet that is updated via reports from SAP. The reports run from Sunday-Saturday for the current week. The days in the future only carry a zero value since they have not occurred yet and cause my formulas to display the zero value. I'm looking for...

I am looking for a formula that no matter what today date is it will always return the dates for the following Saturday and Sunday.

Hi Folks, I have found a great macro which allows you to check for the existence of folders in a file-path matching: Year, Month and Day (i.e., creating the folder if it doesn't exist). For instance, if the FilePath starts: C:\Temp Time Sheets\ it checks for C:\Temp Time Sheets\2019\ C:\Temp...

I have an issue (or lack of understanding) of the Weekday function (Excel O365) Formula in Column B is =weekday(Col A,2) cell in column B formatted as general Formula in Column C is =weekday(Col A,2) cell in Column C is formatted as ddd Column A Column B Column C...

Alright guys, I'm pretty new to VBA and am working on a fairly simple userform to display data from multiple sheets in one place. I need help with one aspect, I need to convert days of the week to actual dates. The trick is I need to find the next available day of the week based on today's...

<colgroup><col><col><col><col><col><col><col></colgroup><tbody> Telecast Date Telecast Day Day Start Time End Time Time Zone Answer 1-Aug-19 Thursday Weekday 7:00:00 12:00:00 Morning Prime Time 2-Aug-19 Friday Weekday 17:00:00 21:00:00 Evening 3-Aug-19 Saturday Weekend 13:00:00 16:00:00...

Please forgive my appalling lack of Excel vocabulary. I'm not even sure what what I'm trying to do is called. :) I have a spreadsheet to track the time and frequency of occurrences, say phone calls. My data is like: Weekday Date 9:00 hour 10:00 hour 11:00...

I am looking for formula that can tell me if a given daterepresents the first, second, third and so on of that particular weekday. For instance, I have a column with a list of days (columnA), and I have a column beside that (column B) that identifies what day ofthe week that date represents via...

Hi Everyone! So I have an Excel doc that I print out for a hand written report. I have a week beginning cell that should always show the upcoming Monday date, UNLESS today is Monday, then it should show today's date. I usually print this out on Friday, but last week did not have time to get it...

Hi, I’m creating a calculator which will show an expectation each day someone is at work. Currently this is what I have, so on a weekday it returns 5, weekends return 8. However I would like it to return an empty cell if C3 is empty as this means they are not in. =IF(WEEKDAY(A3,2)>5,8,5) How...

Hello everybody, Back again after sooo long I am facing a problem with the weekday function that after a bit of googling I saw that is a common question but I couldn't find an answer. Say in cell A1 there is the date 10-01-2019 which is a Thursday =weekday(A1,1) gives a 5 (correct). Applying...

Hello, In my pivot table i'm grouping my date by days with 7 days. That gives me a start and end date. I would like to get the weekday at the start and end date. Date format: ddd dd-mm-yyyy Is this possible?