Search results

I've asked a couple of times in the thread, to no avail, but in short I should be able to change this so that the week start on Monday and the last two cell in a Row are Sat & Sun. I have tinkered with the template several times, but either I break the calculations so that the day/date are...

So I have a plan that has start and end date/times using one of the custom options - dd mm yy\ hh:mm. What want to do is add new column that checks there is a start date time group, end date time group and the supplies the answer as 1 Day 05:20 or is blank...

I have the following spreadsheet & chart working perfectly and looking how I want it with the exception of the first date which stays as a Comma Style vallue 41699 rather then the custom date format of 1 Mar 14. I have set it as text whilst formatting the axis but it won't play nice. Where...

=IF($D2=2,$B2,"") I just need to run down a column looking for a number and then pull the result from a cell in the same row. What I think this should do is check column D for the first instance of '2' and populate the cell with whatever is in the matching row in Column B, and NOT to return a...

I want to hightlight a number if closed date is populated (the number is a priority and clearly if it's closed it shouldn't be populated). Column A is the Priority, column C is the closure date. So what I want to do is highlight a row if if column A is >0 and column C >0...

This is a cross post from this the Risk Map page to allow the spreadsheet to be attached.

This is the formula: =COUNTIFS(A2:A8, "Refurb",B2:B8,">=TODAY()-7",C2:C8, "None") In short I need to count if: Workstream = Refurb Date=last 7 days Fail=None However, getting an answer of 0 when it should be two as per the attached test sheet. it appears the date test is the problem.

If there is a date in column A, Countif column B is blank (count blanks if there IS a date). This is my formula, however I am getting the answer of 1 rather than the 2 expected? =COUNTIFS(A1:A6, "*",C1:C6, "") See attached for example.

Essentially I have a monster spreadsheet that need to do one of thre things. Highlight 3 columns in Red if Actual date is greater than Target. This works in the attached. Highlight 3 columns in Green If target matches actual. This doesn't work? No highlighting if not any of the above. One...

Columns AA, AD and AG are populated with dates. I need to confirm if any of those contain a date that is plus or minus 7 days from Today() however my first stab results in my test dates (2 +/- 5 and 2 +/- 14) all being FALSE. Clearly I need to get it working before I start nesting, but not...

I am using CONCATENATE to generate 3 columns of information in a bar chart axis as this seems to be the only way to have more than the axis title. I am combining the: Task Owner Basline (date) This works: =CONCATENATE(B2," │ ",C2," │ ",(TEXT(E2,"dd mmm yy"))) resulting in: Discovery │ Bill...

What I want to do: Enter two dates, select the RAG (corresponding bar matches the RAG colour) chart does the rest. What I have done: I have a stacked bar chart which generates a Gannt which works fine. I have tried to combine that the Peltier method (separate out the values). In this...

Hi, I normally poke through here for work related matters, however my first post is for home use! Ruby, our Doberman is expecting 11 puppies next week. One thing we must do is track their weights to ensure they are growing and the smaller ones get extra feeds...