sunday

Hi all. I am new to this forum. I have a worksheet where a person has to work 208 normal hours for a basic salary. If he work less than 208 but has any sunday or public holiday time then i want to take the difference of normal hours less 208. Then from there i need to pay the sunday hours at...

TABLE 1 <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> NAME SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY A ASBURY 1 1 1 1 1 N PATEL 1 1 1 1 1 1 1 TOTAL </tbody> TABLE 2 <colgroup><col width="72" span="8" style="width:54pt">...

I am trying to do a formula for a date that shows the week of with Sundays date. I am using: =AC2-WEEKDAY(AA2,3) which returns the week of date as Sunday for my 2017 dates. For some reason when the date changes to 2018, the formula is then giving Monday as the week of date instead of Sunday...

Trying to get the result of what dow1 equals to enter in the later line code code, so it will either be F12, G12 or H12. Cannot quite get it to work - any ideas please? If (Workbooks("Forecast Template.xlsx").Sheets("Revenue").Range("B6") = "Sunday") Then dow1 = "H" If...

In column B, the following options are available: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Session 1: Sunday July 1st – Friday July 6th, Session 2: Sunday July 8th – Friday July 13th, Session 3: Sunday July 15th – Friday July 20th...

Equals Cell Above So here is the dilemma. My last post involved setting a conditional format to set each row that is a Sunday row to be highlighted a specific color. This works great, such that when I copied the 2018 sheet and renamed it to 2019, adjusted the top 2 column A cells which then...

I have a worksheet which is used to create two week schedules....two weeks - Sunday through Saturday. Is there an easy way to have it populate the days of the month in the cells for the 14 days? Ie, if I entered 14 in the cell below Sunday - the cells below the days for the next two weeks...

Hi, please help me Formula to sum working hours excluded saturday and sunday to calculate value of cell, employee working overtime hours in 25 days excluded saturday and sunday from previous month 26th to current month 25th. also separate sum for saturday and sunday too thanks

Column A contains dates. Column B should show the corresponding weeknumbers of the date mentioned in column A. I currently use: =WEEKNUMBER option. Unfortunately it should the weeknumbers, but the weeknumbers in excel by default starts at Sunday. How can I change this to Monday? Please advise.

Hello all, I was wondering of a simple process to compare schedules to eachother as far as being 100% matched 80%, 60%, etc. For example: A supervisor with Saturday & Sunday off who works Mon-Fri 9:00 AM to 6:00 PM. An agent going to the supervisors team who is Saturday & Sunday off, works...

Hi all, Please teach me how I can display only columns with certain text in Excel 2007? There are a lot of help on filtering rows but I am hoping to create either a toggle button or set up a reference cell (say "B4") along with a VBA to display columns with selected days only. For example...

I am using Excel 2007 and asking your help for the best (and the easiest) way to highlight the names of people who have 6-month of consecutive attendance every Sundays. My worksheet's layout are as follow: Column A: Last Name Column B: First Name Row 9: Dates (with "S9" as Jan...

I need to distribute the Number of nights (column C) to column E to column K (Sunday to Saturday). The starting point of cascading is based on its Check in Day (column B). <tbody> check in date check in day No. of nights Sun Mon Tue Wed Thu Fri Sat 1/22/2017 Sunday 4 1 1 1 1...

Hey, Not sure how to go about this but I need to populate a cell with the value of 1 - 52 using my work calendar. Currently I'm in week 1 so throughout this week, whenever I open the workbook A1 needs to be "1" and then on Sunday - Saturday if I'm to open the workbook it needs to be "2"...

<colgroup><col><col><col><col><col><col><col><col><col span="3"></colgroup><tbody> Start time Finish time Hours worked Billable hours Tuesday 29 August 18:00 Wednesday 30 August 07:00 13 20 Sunday 03 September 18:00 Monday 04 September 06:00 12 24...

Hello, I occasionally work set shifts, which includes an overtime rate. I would like to create a table which looks like the following: <tbody> Start time Finish time Hours worked Billable hours Tuesday 29 August 18:00 Wednesday 30 August 07:00 13 20 Sunday 03 September 18:00 Monday 04...

Afternoon Is there a more appropriate way to delete row if value is Saturday or Sunday than the following Sub deleteSatSun() Dim dlrow As Long, ws As Worksheet Set ws = ActiveSheet For dlrow = ws.Range("B" & Rows.Count).End(xlUp).Row To 2 Step -1 If ws.Range("B" & dlrow).Value...

Hi all, I need to invoice my client for security services. The rate is not fixed but based on shift timings which is: 06:30 to 18:30 day shift 18:30 to 06:30 night shift. Also rate is different for saturdays and Sunday. I am currently doing it manually. Any help will be much appreciated.

Hi this formula gives me 7/23/2017 and changes this Sunday to 7/30/2017. It changes every Sunday. What I need help for it to do is to wait till Tuesday to change the date. So example: I need it to change to 7/23/2017 when Tuesday hits meaning tomorrow rather then it change on a Sunday and then...