Referencing a cells value in another formula

[Ritik]

Hello all,

I am trying to reference a cells value in a formula I am trying to use, however I do not think it is working because the cell I want to reference has a formula in it, which is then formatted to give a specific number.

E.G.

Cell B2 has the value I want to reference in my formula. Cell B2 contains =WORKDAY(DATE(A2,A3,0), 1)
Cell A2 contains 2023
Cell A3 contains 1

This formula gives me the first working day of January 2023. I then proceeded to format it so it shows as just a numerical date "2"

Now I want to reference this cell B2 which contains this formula, =WORKDAY(DATE(A2,A3,0), 1) but outputs "2" , to be used in another cells formula with the formula being

=IF(ISNUMBER(MATCH(B2,V2,0)),"Holiday")

Lets say V2 contains a number 2.

If V2 contains 2,it would match with the output of cell B2 (which is a formula, that is then formatted to a numerical day value), it should then display holiday.

however this is not the case, it shows False. When I change the B2 in the formula to 2, it works fine, however I would like it linked to cell B2.

=IF(ISNUMBER(MATCH(2,V2,0)),"Holiday")

Let me know if I can clarify anything.

 

[etaf]

that cell will have a full date reference as a Number 44928 2nd jan 2023
BUT when you format you asking excel just to show the day - but underlying is the full date 44928

if you just want the day to be used
then
=DAY(WORKDAY(DATE(A2,A3,0), 1))
will give 2
format as a number or general

or if in B2 you need to keep the full date , then you could change the B2 in the match - to use the DAY() formula directly

=IF(ISNUMBER(MATCH(DAY(WORKDAY(DATE(A2,A3,0),1),V2,0)),"Holiday")

OR

=IF(ISNUMBER(MATCH(DAY(B2),V2,0)),"Holiday")

 

[Fluff]

How about

=IF(ISNUMBER(MATCH(DAY(B2),V2,0)),"Holiday")

The reason your formula doesn't work is B2 contains the date, the cell format is irrelevant.

 

[Ritik]

Thank you for your help @etaf and @Fluff:

I used =IF(ISNUMBER(MATCH(DAY(B2),V2,0)),"Holiday") and it worked perfectly. Thank you so much for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[etaf]

you are welcome