Forum Discussion
Excel Formula
Hi I am new to this platform. am also new to excel. Kindly let me know what is wrong with this formula =SEQUENCE(52, 7, 2023). I wanted to produce 2023 calendar. thanks
I appreciate your efforts aimed at helping me to get clear understanding of excel.
i have tried this =SEQUENCE(52,7,44927,1) and =SEQUENCE(52,7,DATEVALUE("1/1/2023"),1) but unfortunately this is the error sign i keep receiving #NAME?
How do i resolve this?
i have tried this =SEQUENCE(52,7,44927,1) and =SEQUENCE(52,7,DATEVALUE("1/1/2023"),1) but unfortunately this is the error sign i keep receiving #NAME?
How do i resolve this?
You may not have access to SEQUENCE.
Try this formula to see if you can generate 1 to 10. If you get a #NAME error then it's the version.
=SEQUENCE(10)- I appreciate all for your efforts. I have detected that the version of excel am using is not having assess to sequence.
I have been able to make use of your suggestions on other machines and all turned out to be perfectly okay.
Many thanks