# sundays

1. ### Calculate number of days excluding Saturdays and 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
2. ### Re: How to count Sundays worked in a specific month based on a cell value

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...
3. ### Exclude Sunday while adding days to a given date

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...
4. ### Count ALL days in a month, except Sunday

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!
5. ### Number of Sundays between dates

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
6. ### Date finding help

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back