Hi,
I have 3 sheets in this file
'Dashboard' is a weekly summary
'James Weekly Data' is a an employee specific sheet with comments entered
'Jack Weekly Data' is a second employee specific sheet with comments entered
I am trying to pull the comments entered for the current week (Today()) and only display those comments in the 'Dashboard' sheet. So far I have used this formula
=IF(AND(TODAY()>='James Weekly Data'!A2, TODAY()<='James Weekly Data'!A3),'James Weekly Data'!B3,"N/A")
While it works fine, I want to ensure that the test moves down the week column to display the relevant date in the 'Dashboard' sheet.
Weekly Data Dashboard.xlsx
Please help.
Thanks!
Bookmarks