return weekday name using text function in vba

HI,

I wrote below code (with in for loop )to display weekday name using text function. (based on excel formula)

Sheet2.Cells(2, i + 2).value = worksheetfunction.text(date(sheet1.Cells(2,1).value,sheet1.cells(2,2).value,Sheet2.Cells(3, i + 2).value),"ddd")


if i=1 then , i want to get day name at shee2.cells(2,3).value=Wed ( if the date is 1-02-2017)

sheet1.Cells(2,1).value = 2017
sheet1.cells(2,2).value= Feb
Sheet2.Cells(3, i + 2).value=1

but above text function is not wokring. error showing at "sheet1" and Error is : Compile Error , Expected: )

regards
shiva

thanks for reply. but the above dateserial function retruns Run time Error 13: type mismatch

Hi YasserKhalil,


Pls find the attachment.


regards
shiva

Change to

Please Login or Register  to view this content.

Thank you YasserKhalil Ji.

Thank you very much Jindon.......