calandar

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top