calendar days vs workday

  1. L

    Calendar with autofilled content based on conditions and exceptions

    Hi All, I’d much appreciate your guidance on how to create acalendar which would auto-populate activities per day based on conditions. I’ve done some Googling but cannot find exactly what I’mafter 1, I’d use one of the Excel Calendar Templates which updatesdates automatically based on...
  2. M

    Company with different calendar year

    Hi everyone, I've been looking for a solution but haven't been able to find one! I hope you can help! My issue is that my company has a different calendar year, it starts in April and ends in March, I want to use the formula to get the Week Number however a simple WEEKNUM() is not useful in...
  3. I

    Calendar for Working Days Auto Entries - Almost Working

    Hi, I'm trying to make what I'm sure ought to be a simple calendar to track two types of work arriving and the time that they must be dealt with in. Work type 1 (addressed) has a receipt day and then three days to be dealt with (labeled day 1, day 2, etc). Work type two (unaddressed) has a...
  4. C

    How many calendar days back from a target date?

    Hello, I hope someone will have an answer for me. I'm trying to count back the number of calendar (not workday) days from a target date. For example, Paul's review is due on 8/1/10. Sixty calendar days before 8/1, x needs to happen. Then 45 calendar days before 8/1, y needs to happen, and so...

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