calandar

  1. T

    Conditional formatting on a cell containing a formula

    Hi all, I am trying to build a calendar so I can change the year and get a new year. I have got the days of the month to work but I want to conditionally format the weekend days. I work where there are 2 weekends. Some operated Fri/Sat and the others Sat/Sun. so I need it to be dynamic. The...
  2. T

    Distribute array of information based on cell value into a calandar.

    Hi, so I have my budget which is in the form of a calandar on excel. Currently I manually type in each individual entry(not including standard bills or credit cards I have formula for that) I am looking for a formula that will allow me to basically download my bank statement and copy and paste...
  3. R

    Logistics Booking Calander/Form

    I have a little bit of a weird request and if anyone can help me it would be very much appreciated. I am trying to create an Excel spreadsheet which will allow me to make bookings of equipment, more specifically we hire out commentary units and public address systems so on the 'home page' I...
  4. T

    Help Calculating Months -3+5

    Thanks for the time in reading this. This is my first post. I am trying to figure out (without any success yet) on how to use excel to figure out my employes PTO. Personal Time Off. This is how it works. Employees must work for three months before getting 5 hrs of PTO. Each month after...
  5. B

    Creating a shift Rota / Calendar

    I am currently devising a rolling shift rota/calendar for a friend and his colleagues who work different shifts (Earlies, Lates and Nights). I want to input an abbreviation/letter (for example 'N' for night-shifts) in a cell and then get excel to automatically repeat that same 'N' entry, every...
  6. R

    Calandar - displaying specified dates

    Good morning all This forum has already shown me how to have today's date highlighted on a calander (which worked like a charm), but I've not quite worked out how to have a date (or list of dates) shown on the calandar. <TABLE style="WIDTH: 492pt; BORDER-COLLAPSE: collapse" cellSpacing=0...

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