sunday

hi, Is there a formula that if I put a date in a cell a1 , b1 will then return that weeks sunday date? Example:- a1 - 17/12/18 b1 = 23/12/18? many thanks in advance. Trevor3007

Hello and thanks for helping Column C has dates formatted mm/dd/yyyy I would like a VBA code to search column C, and any date that is a Sunday, the word Sunday would then appear in column B next to that date This should only return Sunday, no other days need to appear in column B Thanks Thomas

Racking my brain to get the following to work: =IFERROR(IF(D5=0,"",D5+45),IF(D5="","",D5+7-MOD(D5-1,7))) D5 being the source date that I'm adding 45 days to and then rounding to the following Sunday. Honestly wouldn't mind figuring out the previous Sunday as well. We are trying to set...

Re: How to count Sundays worked in a specific month based on a cell value Hi All, I need to count the Sundays that an employee worked in a month. The below table is what I am using. According to this table the employee has worked one Sunday out of the two Sundays shown in the table. The...

Re: How to calulate hours worked on Sundays in a specific month Hi, I would like to know how to add all hours worked on the sundays in a month. An employee might not work every Sunday in a month. Some employees will work one Sunday, others might work 2 or more and some might not work any...

<tbody> A B C D E F G H I J K L M N F 1 Name Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday 2 John 8 AM 8 AM 8 AM 8 AM 8 AM OFF OFF OFF OFF 8 AM 8 AM 8 AM 8 AM 8 AM 3 David 8 AM 8 AM 8 AM OFF OFF 8 AM 8 AM 8 AM 8 AM 8 AM 8...

If a particular date is a Saturday or Sunday how can i flag this to pick up the next working days date i.e. the following monday

I have a table with dates and 3 sets of quantities that I want to sum up if it is a Friday, Saturday, or Sunday. How can I do this?

I've got my statement wrong or I'm trying to write this incorrectly. I have two drop down lists. M5 has 4 statements - Saturday, Sunday, Monday, Tuesday M6 has 3 conditions - Open, Lunch, Closed I am trying write an IF statement. Saturday & Sunday have the same answer for Open & Lunch =...

Hi all, I have been trying to find a formula that will tell me how many hours fall between two specific date/time ranges. So Range One Starts: Friday 01:00 Ends: Sunday 17:59:59 Range Two Starts: Sunday 18:00 Ends: Friday 00:59:59 The ranges can be variable and I need it to round up to a...

Hello, I am trying to make excel make me a list of my students based on the day. For example: I want excel to check who is here on Monday and show me the names in a list on "F"

Hi All, Could someone help with with the condtional formatting of dates and differnet rules please. If A1 has a date of : Monday - Friday 07:00 - 21:00 and Saturday - Sunday 07:00 - 16:30 = B1 to be coloured AMBER Monday - Friday 21:01 - 06:59 and Saturday - Sunday 16:31 - 06:59 = B1 to be...

If date formula equals Sunday, change to following Tuesday. I have a complex formula where the end user enters a start date in one sell, and then can select lead times in either days or weeks (7 days) that eventually roll up to a final date. The problem is that I can't have any of the...

I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday. <tbody> H I J 40 Car $445 25 41 Groceries/Gas $150 Saturday </tbody> Below you can see on the 25th of the month (Saturday) the $445 took (I27) but not adding in the $150...

Hi there, I maintain aworkbook that has a sheet where the staff schedule is laid out in columns asfollows: A = Staffmember name B = MondayStart Time C = MondayEnd Time D = TuesdayStart Time E = TuesdayEnd Time etc., endingwith M/N for Sunday Start/End Times Anothersheet includes relevant...

Hi all, I am setting up a calendar / planner on excel at the moment and I need the exact same text that I have typed into the first sunday cell to repeat on each every other sunday cell but at 9 weekly intervals. Anyone any ideas? Much Appreciated

Column "O" has the Award Date Column "R" has the Bid Amount I am trying to get Column "V" to show the Bid Amount in Column "R" only if the date in Column "O" is withing this week Sunday through Saturday and blank if not within this week...

Good morning all..... Done a lot of looking and have made some progress but stuck now.... My fiscal year does not always start on the same date....This is for some accounting reason...but it's been this way forever as far as i know... What i do know is that the fiscal year starts on the SUNDAY...

Hey Guys, I'm trying to output the dates of the weeks (Monday to Sunday) of any month given the following criteria: First week of month is if the first Thursday falls on the first week of the month. and correspondingly the last week if the next month's first Thursday falls on the first week of...

I am trying to solve a scheduling problem in excel. What I have are dozens of Tasks similar to this output. <tbody> Saturday 3-10-18 6:00 AM Sunday 3-11-18 12:12 AM Length of task 18.3hours Saturday 3-10-18 6:00 AM Sunday 3-11-18 12:12 AM Saturday 3-10-18 6:00 AM Sunday 3-11-18...