planner

Hi! As i was trying to scan online for a solution, i couldn't find unique solution. I am trying to create a template for a range of spreadsheets that would be used as a dailly planner for 365 days in a year, 2025.to be specific. What i want to automate is date that would sequentally rise by 1...

I want to create a chart that takes the amount of hours per project and spreads it over the time period it lasts. The chart should show a stacked column per week with hours for all projects. X-axis: Week no. Y-axis: Hours.

Power Bi is not displaying content from the office planner.Our requirement is to office planner content in Power Bi Page.We are using tile with link set to office planner however we end up with error message "Content cant be displayed in iframe".Is therr any other method for dislaying the...

Hello, I've created a weekly planner for revision, it has a start date, duration and % completed. The dates are in columns eg 29/03 am and 29/03 pm... It's all great when i enter the duration as 1 day and it highlights both AM and PM for that day. Can anyone tell me what is the conditional...

I once used a document which I think was created on excel which was like a weekly planner but had shapes/icons listed in a key. You could drag and drop these icons in to the planner as much as you needed without it affecting the key. I am wondering if anyone can shed some light on how this was...

Hello, I'm trying to make a planner that adds every week a new week and removes the past week every week is one column. So for example the first week is the current week, and starts in column I. next week is in column J and so on. The past weeks have to be removed. Is there a VBA code to make...

I have a report that links data from other worksheets. The names of these worksheets change annually, for example "2018 Jobs Planner 2.0.xlsm", will become "2019 Jobs Planner 2.0.xlsm" next year.I am trying to calculate the name of the worksheet for the current year so it does not need to be...

I have a Worksheet with 2 Tabs. Tab 1 = Planner, Tab 2 = Source Data. Tab1 - Planner, Names and dates of the month <tbody> 1/6/18 2/6/18 3/6/18 4/6/18 5/6/18 6/6/18 7/6/18 8/6/18 9/6/18 Person1 Person2 Person3 Person4 </tbody> Tab2 - Source Data...

Hi all, I am trying to make a cell highlight in red if there are more than 1 condition present. The table below represents a work rota and also a holiday planner underneath. The initials of each employee are entered into the rota for each day they are at work. If they are on a rest day (RD)...

Hi all, I am new to the forum and not very experienced with formulas in excel. I've created a workload planner which has multiple rows for each person based on the aspect of work they will be completing each day. Basically I now want to have a simplified table on a second sheet that will auto...

Hi Everyone, I have had so much success using this site but I am facing another challenge here in excel. I have version 2013 on my windows computer. Goal: The goal is to create an easy to use schedule creator for the shifts here at my work. I am trying to make it very simple to use so that...

Hi, can someone help with this error in excel. My formula is IF(WEEKDAY(DATEVALUE(MoMonth&" 1, "&MoYear))=COLUMN(B$2),1,IF(LEN(A6)>0,A6+1,"")) but cannot manage to solve it by meself. Its a week planner that adds the correct date and corresponding task to the day. Any help is much...

There are a few things I'm not getting. (1) Why is there an end date that appears to serve no purpose? I thought it might help print 7 daily schedules after putting in a start date. But I see no code for this? (2) How is the schedule meant to be used? Printing one day at a time, or is there a...

Hi I am building a year planner to track the progress and milestones for cost saving projects. I have one worksheet that contains all the milestones, due dates and the savings per month. My question is: Is it possible to build a calender where the cell displays the date (like a little...