Forum Discussion
Solved
Display number of days in different months.
Dear All. I have a timesheet. When I entered the number: 1-12 as a month in a year, the table displayed the number of days in this month. But the issue is the days in a month are different so each...
Alvin1007 SEQUENCE() function can give you desired result. See the attached file.
=SEQUENCE(DAY(EOMONTH(DATE(C2,B2,1),0)),,DATE(C2,B2,1))
- Dear Mr. Harun24HR.
How wonderful you are! Thanks a lot for your support. You are my life saver. It makes my timesheet easiest than ever.
Thanks again.
