Replies

Braddy,

The syntax for the weekday formula is: WEEKDAY(serial_number,[return_type])

In your example your formula was =Weekday(E4). Your formula could have been WEEKDAY(E4,2). The return type of 2 would indicate that the return value starts with Monday whereas a 1 or omitted return type, the return value starts on a Sunday (see the table below)

Return_type Optional. A number that determines the type of return value.
Return_type Number returned
1 or omitted= Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Microsoft Excel.
2= Numbers 1 (Monday) through 7 (Sunday).
3= Numbers 0 (Monday) through 6 (Sunday).
11= Numbers 1 (Monday) through 7 (Sunday).
12= Numbers 1 (Tuesday) through 7 (Monday).
13= Numbers 1 (Wednesday) through 7 (Tuesday).
14= Numbers 1 (Thursday) through 7 (Wednesday).
15= Numbers 1 (Friday) through 7 (Thursday).
16= Numbers 1 (Saturday) through 7 (Friday).
17= Numbers 1 (Sunday) through 7 (Saturday).

Example: E4=10/17/2016 is a Monday

=Weekday(E4,1) or just Weekday(E4) returns a 2 because Monday is the second day starting from Sunday

=Weekday(E4,2) returns a 1 because the return type of 2 specifies that Monday is the first day of the weekdays

Essentially, it is setting the starting point and returning the number of weekdays from that point.

HTH,
Maud

Thanks very much for your reply its much appreciated
Braddy60

weekday(E4) returns 4 as 10/19/2016 is a Wednesday which is day 4 of the week. The fourth choice in your formula is Wednesday and therefore the value returned. Your did not specify the return type so it defaults to Sunday as day 1

HTH,
Maud

Hi thanks for your reply could you elaborate a bit on the meaning of return type please

Thanks
Braddy60

Hi RetiredGeek

Yeah I had a senior moment I forgot the change the F5 location

Many Thanks for your reply

Braddy60

What options do you get when you click on the Resolve Button drop downs?

Also in Control Panel > File Explorer Options > View tab, make sure the radio button nest to “show hidden files” is set along with the check box clear for “Hide extensions for known file types”

Jerry

Hi resolved by re-installing Kaspersky!

Thanks to All who replied

Try FreeFixer as that will show all files of which some can be deleted.

http://www.freefixer.com/

Hi Sudo tried that it couldn’t find it but kasperky tells me its there but can’t find it

Thanks anyway

Hi PaulT I have tried all these things which probably mean my windows is incomplete somehow 42739-Peer this is the latest error.

Thanks to everyone but I am prepared to give up on this now

Thanks Braddy

Hi jwoods I navigated to C:WindowsServiceProfilesLocalServiceAppDataRo amingPeerNetworking and the folder was empty and I cant find any of the services mentioned.

Thanks for the reply

Braddy

Hi jwoods I am running the latest version windows 10 home with the new upgrade released this month, I upgraded originally from windows 8.1

Thanks for the reply

Braddy

Hi jwoods Ive have already done that still no joy

Thanks Braddy

Hi BruceR Tried that to no avail

Thanks

Braddy

Hi Coochin

Its not the UK keyboard that effects the @ “” it’s the US that why I am looking for a permanent change to UK

Thanks

Thanks to all who replied

Braddy

Hi Maudibe

Thanks for that, I don’t want to impose but is there a way to show the lowest and the highest in the same column

Hi MatinM

Thanks for the reply but Maudibe worked for me
Braddy

Hi Rory

That’s exactly what I needed

Thanks very much
Braddy