sundays

  1. B

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

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

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

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

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

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

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top