Convert Numbers to a full Date

[ONP Nino]

Hello, I am trying to convert numbers into a full Date but am having a hard time.
data is as follows:

A1 = 5 (workday number of week - Friday)
B1 = 3 (week number of month of April)
C1 = 4 (month of Apr)
D1 = 23 (Current year of 23 and not 2023)
E1 = Result (the result should be "21 Apr 23 Friday" )
But I am getting "20 Apr 23 Friday" as a result with Current formula in E1 "WORKDAY.INTL(DATE(D1,C1,0),B1,REPLACE(1111111,A1,1,0))"

How can I fix this problem?
Thank You for the hepl
OP

 

[awoohaw]

what version of excel are you using? Please update your profile with the version you are using so the version will show up in your profile button?

Can you give more context as to the nature of your dilemma? Maybe there is another way to approach your question.

Thanks.

 

[ONP Nino]

what version of excel are you using? Please update your profile with the version you are using so the version will show up in your profile button?

Can you give more context as to the nature of your dilemma? Maybe there is another way to approach your question.

Thanks.

Hi, I am using office Excel 2019. I am having a hard time finding the profile to update it.
Thank you

 

[Dave Patton]

Workday.xlsm
	A	B	C	D	E	F
1	5	3	4	23	21-Apr-23 Friday	21-Apr-2023
2	DOW	Instance	Month	Year
3	4
5c

Cell Formulas
Range	Formula
E1	E1	=WORKDAY.INTL(DATE(20&23,C1,0),3,REPLACE("1111111",A1,1,0))
F1	F1	=WORKDAY.INTL(DATE(20&23,C1,0),3,"1111011")

 

[ONP Nino]

Wow, Thank you very Much Dave for the solution and quick reply. Works super
Have a great day
Cheers
OP

 

[Dave Patton]

Thanks for the feedback.