Hi I am having a problem displaying the relevent date for a day entered as text.
I have a dynamic start and end date that shows the Monday and Friday dates for the chosen week, I have a text entered day that I need a formula to match the correct date against the entered day.
Please see the example sheet for details and desired outcome.
Thanks in advance.
JD
Hi
Paste this formula to c6 cell
=MATCH(A6,TEXT(ROW(INDIRECT(VALUE(A2)&":"&VALUE(B2))),"dddd"),0)-1+A2
Its an array. Hit Ctrl+Shift+Enter
Appreciate the help? CLICK *
Hi,
One way -see attached
useswith a drop down validation in A6 to assist entry.Formula:
Please Login or Register to view this content.
Last edited by Richard Buttrey; 03-21-2014 at 04:49 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
or you could use
=INDEX(ROW(INDIRECT(A2&":"&B2)),MATCH(A6,TEXT(ROW(INDIRECT(A2&":"&B2)),"DDDD"),0)) or
=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A2&":"&B2)),"DDDD")=A6),ROW(INDIRECT(A2&":"&B2)))
Last edited by hemesh; 03-21-2014 at 04:50 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thanks guys great answers - going to go with Richard Buttrey's for simplicity.
Thanks again
JD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks