week day

  1. L

    Conditional Formatting: How to set deadlines using weekdays

    Hi guys, I've been trying to work this out for over a month! I have a spreadsheet that includes due dates for certain stages of a complaint. Stage 1 must be actioned within 5 days of the due date, Stage 2 must be actioned within 10 days, Stage 3 is 30 days and Stage 4 is 56 days. The days...
  2. S

    Data dependent on date

    Good Morning, I have an excel spreadsheet where I input certain data per week and for each additional week I have to create a new sheet. I was wondering how could I make it where I could have a drop down of the date and then enter my numbers for the week and it save the numbers I enter and I...
  3. Hrishi

    How to calculate last date of a week from any date assuming that week starts on monday

    Hello, I want to calculate the last date of a week from any date with presumption that week starts from monday and ends on sunday. I have a formula =IF(WEEKDAY(date)=7,date+1,date+(7-WEEKDAY(date)),,, BUT this does not work on date 1-1-17 and 31-12-18 etc may be it because this day is either...

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
Back
Top