weekday

This program works seamlessly when I have the cell referenced to today's date and it is Friday, but when I want to type in a date that isn't =Today() for some reason it does not recognize that the typed in date is a Friday. Can someone help me figure out why that is? :confused: From my...

Hi Gurus, Happy new year 2019. I have entered 02-01-19 in a cell B6 and want " Wednesday" in cell C6. Which formula do I use. Thanking you, AFD

Hello. how can i add weekday to the formula below. right now the formula im using is giving me the average interval, i need it to say per weekday per interval . im trying to get the average for all mondays in the year at 8:30 am. {=AVERAGE(IF(($A$2:$B$18927)=$E2,$C$2:$C$18927))} a...

Hi guys. I have a Rota sheet that I'm doing some work on. I have an if function in to retrieve the data from the master Rota for each user if they are in that day. The issues I'm having is the coloum beside it. I want to put a formula in that says for example if b4 is not empty weekday is...

Hi there. Im using this formula in Cell N4 ="Week "&(N6-($D$4-WEEKDAY($D$4;1)+2))/7+1 N4 has general formatng. This work as a charm. I get the output "Week [and a single digit number]" However, I need to control this from VBA The code: Private Sub Commandbutton1_Click()...

I wasn't sure how to search this - I've done searches, but none really address what I'm trying to accomplish -- but if you have another thread to refer me to, I'll go there! Otherwise, Ideas, please! I am moving my "to do" list from an online service that's raising its fees to an Excel...

Hello! Is there a quick way to generate a list of the weekday dates between a starting and an ending date? Without weekends? Thanks!

Hello and thanks for reading, I have a list of dates in Column A, and want to analyze them between a start date and an end date (inclusive, encoded in two cells elsewhere, user-entered); within the list, some dates are duplicated by design to represent multiple occurrences of a given event...

Hi all, I have read many threads regarding the calculation of working hours between two dates, including the following thread https://www.mrexcel.com/forum/excel-questions/426101-calculate-only-working-hours-between-two-dates-excluding-weekends.html and the great answers from member barry...

Is there a function you can put in a cell that will calculate whether a date that is entered in another cell is a weekday, weekend or public holiday?

I need to find the Monday or Wednesday prior to a given date minus 4 days weekdays in order to Calculate a submission date. Examples: Date given is 7/31, then I want to return 7/23/18 Date given is 7/26, then I want to return 7/18/18 Date given is 7/25, then I want to return 7/18/18 I have...

Hi all, New here, need some assistance. I've searched everything and everywhere, can't seem to find a solution, so perhaps you can help. So the premise is as follows, I need to calculate turnaround time, anything older than 2 days is outside the agreed turnaround time, anything less than 2...

Hi, I have a date which I will need to increment the date by a day, month or year from the actual date. This is based of a list of fields below and is different per the input. Also each resultant date has to be a business day i.e not a weekend day or a bank holiday. I will forgo the Bank...

Hi. I've never used Excel to calculate dates before. I have a basic grasp of some date related functions but not enough to be able to solve the following problem. I'm hoping someone with more knowledge than I have will be able give me some help. Basically, I need to display the next (date)...

I have a spreadsheet (duh!) that uses dates for nominations of natgas. On Monday, I nom for Wednesday (highlighted), on Tuesday, I nom for Thursday (highlighted), etc. The problem comes when today's date is a Thursday, I want the conditional formatting to highlight Saturday, Sunday, AND Monday...

Hi! I'm working on a class for managing two dates. Right now I need a very simple WeekDay function, with the following syntax: oMyObject.WeekDay(dDate As Date) As Long The method looks, not very surprisingly, like this: Private Function WeekDay(dDate As Date) WeekDay = WeekDay(dDate...

The function =TEXT(A30,"dddd") will place the text of the day of the week dependent of the cell value. 1 = "Sunday", 2 = "Monday" etc. But (apart from using multiple iff else statements), is there a reverse of this that will provide a value dependent on the text of the day. IE "Sunday" = 1...

hi I have a gantt chart in excel and i have the following dates colored 06/11/2017 - 14/11/2017. The duration of the project is 9 weekday so I want the cells to color weekday. My start date and end date to the left is fine and excludes weekend (because I've put a weekday formula in) but I...

Hi everyone This has been driving me around the bend and have decided to throw it out into the forum as I've tried numerous connotations, searched high and low for a solution and can't crack it. What I'm trying to do is populate the cell in column N with 8:00 if the date in column A of that...

Afternoon folks, I created a spreadsheet to monitor my time at work and also the overtime. now the rates vary from weekday to the weekend so I was trying to use a SUMIFS to count the weekday over time i had done in a certain period (usually 4 week blocks) and then another one to count the...