Hi all
I need cells F4 & G4 filled in with the Week number (H3:S3) based on the x in the cell underneath.
In the attached sample, F4 should be Week 4 and G4 should be S4.
Thanks in advance!Finding start date and end date.xlsx
Hi all
I need cells F4 & G4 filled in with the Week number (H3:S3) based on the x in the cell underneath.
In the attached sample, F4 should be Week 4 and G4 should be S4.
Thanks in advance!Finding start date and end date.xlsx
Try this......
In F4
and copy down.![]()
Please Login or Register to view this content.
In G4, try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter. (i.e. after placing the formula in G4, hold down the Ctrl+Shift and then press Enter)
and copy down.![]()
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks that works for me!
Glad to help. Thanks for the feedback and rep.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks