Formula to give me the first day of the month (but not sat or sun)

[tonywatsonhelp]

Hi Everyone,

In cell B7 I have a date
I want to caculated nexts months first day of the month, from that date and return it but (if its sat or sun skip to Mon)

So if my date was 13 April 2023 I want Monday 1st May 2023

Please help if you can

Thanks
Tony

 

[Fluff]

How about

=WORKDAY(EOMONTH(B7,0),1)