Show Required Tasks

**SeagullWardy** · 06-12-2012, 01:47 PM

I have a spreadsheet with a list of task. In one of the columns I have either daily, Monday, Tuesday, Wednesday, Thursday, Friday or the 1st of the Month. This relates to when the task needs to be carried out. What I want is to be able to automatically display either on the same sheet or another sheet the tasks that are required on the day I open the spreadsheet. For example if I open it on Friday 1st June 2012, it would list all the daily tasks, the tasks for Friday's and the tasks for the 1st of the month. To make it a little harder if the 1st falls on a weekend then I need the tasks for the 1st of the month to display on the Monday after this.

Can anyone point me in the direction of where to start? I am guessing it is going to need to involve some level of programming rather than just formulas.

**SteveG** · 06-12-2012, 02:12 PM

Hi,

Does the attached work for you?

HTH
Steve

return tasks.xlsx

Sorry, to account for the first falling on a Sat or Sun modify the formula in C2 to:
=IF(OR(B2="Saturday",B2="Sunday"),"",IF(OR(DAY(A2)=1,AND(DAY(A2)=3,B2="Monday"),AND(DAY(A2)=2,B2="Monday")),VLOOKUP(B2,$H$2:$I$7,2,FALSE)&", "&VLOOKUP("1st of Month",$H$2:$I$7,2,FALSE),VLOOKUP(B2,$H$2:$I$7,2,FALSE)))

HTH
Steve

**SeagullWardy** · 06-12-2012, 02:23 PM

Thanks while not exactly what I need I can use the formula to work it out.

Show Required Tasks

LinkBack

Thread Tools

Rate This Thread

Display

Show Required Tasks

Re: Show Required Tasks

Re: Show Required Tasks

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions