work days

[zoharb]

=EOMONTH(B2930,-1)+1
This formula finds 1st day of the month of the date it refers.
I want to find the weekday of that first day
Eg
is return when this formula refers to this date
1-jun-24
which is a saturday
I want to make that formulas + workdays in that months(20 in JUN24)

 

[awoohaw]

To get the weekday number of the first day of a month, given any day in that month. Assume your data is in cell B2930:

=Weekday(EOMONTH(B2930,-1)+1))

Note there is an optional argument for the WEEKDAY() function you can use in order to reflect a different number for the weekday.
I'm not sure what you're asking for in the last sentence. Can you give some examples of what want to see/calculate? Please include expected results.

 

[Phuoc]

Try this

=NETWORKDAYS(EOMONTH(B1,-1)+1,EOMONTH(B1,0))

 

[awoohaw]

Try this

=NETWORKDAYS(EOMONTH(B1,-1)+1,EOMONTH(B1,0))

Now I understand what the OP was asking!

 

[zoharb]

weekday of that first day
Eg
is return when this formula refers to this date
1-jun-24
which is a saturday-------still cant get saturday.
Awoohaw sir formula gives 7 (weekday number) but I want sat(Ihave tried "ddd" but its not giving the result

and can append your formula of networkdays after that?

 

[awoohaw]

The weekday gives a number, not a name of the weekday.
If you want the name of the first weekday of the month that is in cell B2930, then use this:

=Text(EOMONTH(B2930,-1)+1),"ddd")

Note that this changes the value to text and cannot be used is date calculations.

I don't understand what you mean by

and can append your formula of networkdays after that?

Can you please give and example of what you mean?

 

[zoharb]

Respected Sir awoohaw,
I was mentioning this was to use append(&"-"&)
=NETWORKDAYS(EOMONTH(B1,-1)+1,EOMONTH(B1,0))&"-"&TEXT(EOMONTH(B1,-1)+1,"ddd")
output is -------20-sat
we are designing excel sheet so that based on the (networking days days in a month, production possible can be found out(eg our machines produces 200 units a day , so an order of 4000 is possible in MAy as it has 23 networkng days but somewhat impossible in JUN as there are only 20 networking day of which 1-2 days may not generate needed production based on various other criterias.