Workday calendar

Question

Hi,
I've put together a workday calendar, but, A, are there more efficient ways and B

is there a way to use Workddays in the sequence of some other method?

This is what I have .

=LET(d,DATE(YEAR(TODAY()),1,1),dplus,EDATE(d,12),count,dplus-d,

dr,SEQUENCE(count,,d,1),result,IF(WEEKDAY(dr,2)=6,"",IF(WEEKDAY(dr,2)=7,"",dr)),

FILTER(result,result<>""))

Richard.

Answer 1

Hi,

In cell A2, enter this formula

=LET(diy,DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1)+1,lgc,DATE(YEAR(TODAY()),1,1)+SEQUENCE(diy,,0),FILTER(lgc,WEEKDAY(lgc,2)<=5))

Hope this helps.

Answer 2

Hi RichardDrake1505,

Thank you for reaching out. My name is Leo, a user just like you. I'd be happy to help you with your concern.

You can consider using the WORKDAY function or combining SEQUENCE with other functions. Here is an alternative approach using the WORKDAY function:

=WORKDAY(TODAY(),SEQUENCE(252),1)

This formula generates a sequence of 252 workdays (assuming a typical work year of 252 days) starting from the current date using the SEQUENCE function and the WORKDAY function. The third argument of the WORKDAY function is set to 1, indicating that weekends (Saturday and Sunday) should be excluded.

Regarding your second question (B), if you want to use the WORKDAY function in a sequence or any other method, you can still use the SEQUENCE function to generate a sequence of numbers and then add those to the starting date. For example:

=WORKDAY(TODAY(),SEQUENCE(252),1)

Your understanding and patience will be highly appreciated. I hope I provided a helpful information regarding your concern! Let me know if you have any further questions. Be safe always!

Best Regards,

Leo

Answer 3

And how about, ]

LET( startdate, DATE(YEAR(TODAY()),1,1),enddate,EDATE(startdate,12)-1,count, enddate - startdate,

result,WORKDAY.INTL(startdate,SEQUENCE(count),"0000000"), FILTER(result, WEEKDAY(result,2)<=5) )

Bringing back all then filtering out so as to stop at the end of the year.

RD

Answer 4

Thank you,

RD

Answer 5

Thank you both,

I did not think of using sequence to generate the day count , in workday / networkday,

I had tried using it but in a different way and it did not really work,

I would still make the count dynamic so used network,

This seems to work pretty well,

= LET( startdate,DATE(YEAR(TODAY()),1,1), enddate,EDATE( startdate,12)-1, daycount, NETWORKDAYS.INTL(startdate,enddate,1),

result, WORKDAY.INTL( startdate, SEQUENCE(daycount),1),result )

Thanks for the help.

Richard.