<div>
Try<br />

<pre><code id="code-20-42947402-1">select case substring(datename(dw,getdate()),1,3) when 'Sat' then 1 when 'Fri' then 2 when 'Thu' then 3 when 'Wed' then 4 when 'Tue' then 5 when 'Mon' then 6 when 'Sun' then 0 end
go</code></pre>
</div>


Try


select case substring(datename(dw,getdate()),1,3) when 'Sat' then 1 when 'Fri' then 2 when 'Thu' then 3 when 'Wed' then 4 when 'Tue' then 5 when 'Mon' then 6 when 'Sun' then 0 end
go

RIAS

<div>
Logic:<br />
<br />
daysremaining = 0<br />
while not dategiven.DayOfWeek = sunday<br />
&nbsp; daysremaiing = daysremaining+1<br />
&nbsp; dategiven = dategiven+1 (day)<br />
end while
</div>


Logic:

daysremaining = 0
while not dategiven.DayOfWeek = sunday
  daysremaiing = daysremaining+1
  dategiven = dategiven+1 (day)
end while

<div>
Hi Experts,<br />
<br />
Thanks for the help.<br />
Misha, thanks will try the code and brb
</div>


Hi Experts,

Thanks for the help.
Misha, thanks will try the code and brb

<div>
Thank you all. <br />
Gustav Brock your code is spot on!!!! Thanks!!
</div>


Thank you all.
Gustav Brock your code is spot on!!!! Thanks!!

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
How can I find a count for many days remaining for a Sunday &nbsp;in that week . <br />
Example: <br />
Date : 24/09/2019 which is Tuesday <br />
The date on Sunday in that week &nbsp;will be 29/09/2019<br />
So the count is 5 <br />
<br />
I will be provided with the current date, need to find the remaining days count till Sunday.<br />
<br />
Regards
</div>
</div>


Hello,

How can I find a count for many days remaining for a Sunday  in that week . 
Example: 
Date : 24/09/2019 which is Tuesday 
The date on Sunday in that week  will be 29/09/2019
So the count is 5 

I will be provided with the current date, need to find the remaining days count till Sunday.

Regards

Find how many days remaining

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.