Hi guys,
In my cells a13 AND A16 I want to have the text displayed:
We are in working, P8 (cell A13)
We are in Delivering, P7 (cell A16)
Basicaly you can see I have a calendar (i am open to suggestions to amend the calendar format) and i want the value from column B for working (P8) to be returned depending on the date in the same line
in b9, you see p9 which should be returned if today's date is between mon 26th - sat 31st july. I hope this makes sense.. I have put what I am hoping to see in cellsA13 AND A16
Thank you for helping!
Bookmarks