I can't seem to get a Formula to return list of task from schedule sheet for current date.

**Shellybelly** · 02-01-2024, 09:53 PM

I need help with a formula to look at a range of task for a certain date and return list of task for the date today (Current date).. I've attached a copy to show.

**ORoos** · 02-01-2024, 10:15 PM

On the 'Today Plan' sheet in cell 'A4' try:

Formula:

Please Login or Register  to view this content.

then pull down.

This formula will check for the date in cell 'A1' (TODAY()) and look for that date in the 'Schedule Plan' row 2. Then return the list items for that day.

Let us know how you go with this.

**DJunqueira** · 02-02-2024, 01:22 AM

You could use this array formula.

Formula:

Please Login or Register  to view this content.

I can't seem to get a Formula to return list of task from schedule sheet for current date.

LinkBack

Thread Tools

Rate This Thread

Display

I can't seem to get a Formula to return list of task from schedule sheet for current date.

Re: I can't seem to get a Formula to return list of task from schedule sheet for current d

Re: I can't seem to get a Formula to return list of task from schedule sheet for current d

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to return date if time exceeds current day

[SOLVED] how to return first date value in a list that equals the current month

Record Current Date When Task Marked as Completed?

Need formula to return certain cell based on the current date

create daily schedule using master task schedule

[SOLVED] Pull needed data from 'task backlog' to populate 'current sprint' sheet

Checkbox Macro to delete current row (Creating a Task-List with Excel)

Bookmarks

Bookmarks

Posting Permissions