sundays

Hi All, Would like to ask for your assistance on this if statement.J2 and H2 are 2 different dates. How do I count the difference(remaining days) without including saturdays and sundays? =IF(AND(M2="NA",I2="No"),0,IF(AND(I2="Yes",J2=0),NOW()-H2,J2-H2)) Thank you Bryan

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

Hey Guys, Can one help me with a formula that adds any number of days to a given date, while adds the number of days all the sundays should be excluded while generating the new date. Example: 1. If the Given date is 12 Jul 18 I wana add 5 days to 12jul18 excluding sundays result date should be...

Hello, Is there a quick way to count all days within a month leaving out only Sundays? <tbody> Month Start Date Total Days Minus Sundays 1/1/2018 27 </tbody> Thanks!

Hello Team, How to know number of Sundays between dates using formula <colgroup><col><col><col></colgroup><tbody> SD ED No of Sundays 4/6/2018 19:01 4/9/2018 23:01 1 4/1/2018 19:01 4/30/2018 22:01 5 4/6/2018 19:01 4/8/2018 21:01 1 </tbody> Regards, Chandru

Hello, Im currently working on a spreadsheet for my work to show what parts we need each week to finish our project, i have been requested to make out all the parts by sundays, and was wondering if putting the delivery date in one cell, if there was a formula that would see say "25-Jan" and put...