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
Without knowing exactly what you mean by "produce a 2023 calendar" I suggest that you review this link, from which I've taken the following screen shot
It appears you are wanting
- 52 rows, one for each week;
- 7 columns, one for each day of the week
- but you've not entered a meaningful start date, nor a step
The correct start would be the value of Jan 1 2023, which happens to be 44927. And then the step is 1
So the correct formula would read =SEQUENCE(52,7,44927,1)
An alternative could be=SEQUENCE(52,7,DATEVALUE("1/1/2023"),1)
At the end of the process, when all the fields of 52 rows and 7 columns are filled, make sure they're all formatted as dates, in whichever of the several possibilities you desire.
- 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?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
