moderated
Re: Where can I learn about formulas for Excel?
inamuddin khan
Because there are 36524 days in a hundred years and if you divide it into 7, you will get the answer of 5217 weeks and 5 days extra. With regards from Inamuddin with the Skype ID: Charlsdarwin1
Sent from Mail for Windows 10
From: Mario
Sent: Tuesday, May 15, 2018 4:47 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
why "Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19" when the date is 11/11/1991?
 Original Message  From: inamuddin khan [mailto:inamuddin09@...] Sent: Monday, May 14, 2018 6:56 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
1. Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19. 2. Take 90 days from year 1901 to year 1990. 3. Take 22 days as leap years because from year 19901 to year 1990, there are 22 leap years. 4. Take 3 days each from January, March, May, July, August and October. 5. Take 2 days each from April, June and September. 6. Take 11 days from November. 7. The final calculation will be: 5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1. 8. Now count it as Sunday 0 Monday 1. November 11 1991 was Monday. Hope that make sense! With regards from Inamuddin with the Skype ID: Charlsdarwin1
Sent from Mail for Windows 10
From: Mario Sent: Monday, May 14, 2018 11:08 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
ok, how would a date like 11/11/1991 be handled?
 Original Message  From: inamuddin khan [mailto:inamuddin09@...] Sent: Sunday, May 13, 2018 9:45 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Yes dear, you misunderstood the calculation. 1. Take 19 days from year 2001 to year 2019. 2. Take 4 days because from year 2001 to year 2019, there are 4 leap years. 3. Take 3 days each from January, March, May that will be 9 days. 4. Take 2 days each from April and June that will be 4. 5. Take 1 from February because the year 2020 will be leap year. 6. Take 8 days from July. 7. The total will be 45 not 36. The final calculation will be: 19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3. So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3. So July 8th 2020 will be Wednessday! With regards from Inamuddin with the Skype ID: Charlsdarwin1
Sent from Mail for Windows 10
From: Mario Sent: Monday, May 14, 2018 5:46 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
date is 7/8/2020 2020  1 = 2019. so start with 19. 4 leap years within those 19 years. so add a 4. starting from January 2020: January, March and May have 31 days. so add a 3. April and June have 30 days. so add a 2. add the 8 days of July. total is 36 divided by 7 (days in a week?) = 5.142 = 5.1. so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is something missing?
 Original Message  From: Chris Chaffin [mailto:chaffin102468@...] Sent: Sunday, May 13, 2018 8:00 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Hello Mario,
As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year.
Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days. Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September. And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25.
Now step 4 is just the result from adding the numbers from step 3. Step 3 was the instructions, and step 4 is the calculation of step 3.
Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week. For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on.
Hope this has been helpful.
Chris
On May 13, 2018, at 7:24 PM, Mario <mrb620@...> wrote:
I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.
 Original Message  From: Dave... [mailto:dgcarlson@...] Sent: Saturday, May 12, 2018 7:33 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Clever and ingenious.
Dave Oregonian, woodworker, Engineer, Musician, and Pioneer
 Original Message  From: inamuddin khan To: main@jfw.groups.io Sent: Saturday, May 12, 2018 16:26 Subject: Re: Where can I learn about formulas for Excel?
Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date?
Let me tell you how you can do it!
Suppose your date is 12/25/2018.
1.
Take 17 that is 17 years of 21st century.
2.
Take 4 meaning that from year 1 to year 17, there are 4 leap years.
3.
Take 3 from the months which have 31 days, 2 from the months which have 30 days and take 1 from the month which have 29 days.
4.
From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December.
5.
Now final calculation is:
17+4+18+8+25=72 divided by 7=10 remaining 2.
6.
Now you can count them as, Sunday 0 Monday 1 and Tuesday 2.
So December 25 2018 will be Tuesday!
With regards from Inamuddin with the Skype ID:
Charlsdarwin1
Sent from Mail for Windows 10
From: Sieghard Weitzel Sent: Saturday, May 12, 2018 9:49 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top).
If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday.
Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25.
the day
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom Sent: Friday, May 11, 2018 6:18 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
Hi,
Following is a formula to calculate the day of the week from an input date.
In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day.
=TEXT(A4,"dddd")
Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all. You’ll just need to experiment.
HTH
Tom
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor Sent: Saturday, 12 May 2018 9:31 AM To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Hi.
I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.
Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.
Thanks for any info.
Have a blessed day and don’t work too hard.
Kevin Minor and the amazing Jilly, Lexington, KY
.


moderated
Re: Where can I learn about formulas for Excel?
Cristóbal
I used to know this parlor trick quite well as a kid, but totally los the skill after the novelty wore off. But yeah, so how many messages ago did this actually stop being anything remotely about Jaws?
toggle quoted messageShow quoted text
Original Message
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Monday, May 14, 2018 4:47 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? why "Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19" when the date is 11/11/1991?  Original Message  From: inamuddin khan [mailto:inamuddin09@gmail.com] Sent: Monday, May 14, 2018 6:56 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? 1. Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19. 2. Take 90 days from year 1901 to year 1990. 3. Take 22 days as leap years because from year 19901 to year 1990, there are 22 leap years. 4. Take 3 days each from January, March, May, July, August and October. 5. Take 2 days each from April, June and September. 6. Take 11 days from November. 7. The final calculation will be: 5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1. 8. Now count it as Sunday 0 Monday 1. November 11 1991 was Monday. Hope that make sense! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Mario Sent: Monday, May 14, 2018 11:08 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? ok, how would a date like 11/11/1991 be handled?  Original Message  From: inamuddin khan [mailto:inamuddin09@gmail.com] Sent: Sunday, May 13, 2018 9:45 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Yes dear, you misunderstood the calculation. 1. Take 19 days from year 2001 to year 2019. 2. Take 4 days because from year 2001 to year 2019, there are 4 leap years. 3. Take 3 days each from January, March, May that will be 9 days. 4. Take 2 days each from April and June that will be 4. 5. Take 1 from February because the year 2020 will be leap year. 6. Take 8 days from July. 7. The total will be 45 not 36. The final calculation will be: 19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3. So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3. So July 8th 2020 will be Wednessday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Mario Sent: Monday, May 14, 2018 5:46 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? date is 7/8/2020 2020  1 = 2019. so start with 19. 4 leap years within those 19 years. so add a 4. starting from January 2020: January, March and May have 31 days. so add a 3. April and June have 30 days. so add a 2. add the 8 days of July. total is 36 divided by 7 (days in a week?) = 5.142 = 5.1. so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is something missing?  Original Message  From: Chris Chaffin [mailto:chaffin102468@gmail.com] Sent: Sunday, May 13, 2018 8:00 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hello Mario, As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year. Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days. Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September. And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25. Now step 4 is just the result from adding the numbers from step 3. Step 3 was the instructions, and step 4 is the calculation of step 3. Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week. For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on. Hope this has been helpful. Chris On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote: I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.  Original Message  From: Dave... [mailto:dgcarlson@sbcglobal.net] Sent: Saturday, May 12, 2018 7:33 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Clever and ingenious. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer  Original Message  From: inamuddin khan To: main@jfw.groups.io Sent: Saturday, May 12, 2018 16:26 Subject: Re: Where can I learn about formulas for Excel? Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date? Let me tell you how you can do it! Suppose your date is 12/25/2018. 1. Take 17 that is 17 years of 21st century. 2. Take 4 meaning that from year 1 to year 17, there are 4 leap years. 3. Take 3 from the months which have 31 days, 2 from the months which have 30 days and take 1 from the month which have 29 days. 4. From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December. 5. Now final calculation is: 17+4+18+8+25=72 divided by 7=10 remaining 2. 6. Now you can count them as, Sunday 0 Monday 1 and Tuesday 2. So December 25 2018 will be Tuesday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Sieghard Weitzel Sent: Saturday, May 12, 2018 9:49 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top). If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday. Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25. the day From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom Sent: Friday, May 11, 2018 6:18 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Hi, Following is a formula to calculate the day of the week from an input date. In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day. =TEXT(A4,"dddd") Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all. You’ll just need to experiment. HTH Tom From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor Sent: Saturday, 12 May 2018 9:31 AM To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hi. I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas. Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential. Thanks for any info. Have a blessed day and don’t work too hard. Kevin Minor and the amazing Jilly, Lexington, KY .


moderated
Re: Where can I learn about formulas for Excel?
Mario
why "Take 5 days from each century that’s 5 from 17, 5 from 18 and 5
toggle quoted messageShow quoted text
from 19" when the date is 11/11/1991?
 Original Message 
From: inamuddin khan [mailto:inamuddin09@gmail.com] Sent: Monday, May 14, 2018 6:56 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? 1. Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19. 2. Take 90 days from year 1901 to year 1990. 3. Take 22 days as leap years because from year 19901 to year 1990, there are 22 leap years. 4. Take 3 days each from January, March, May, July, August and October. 5. Take 2 days each from April, June and September. 6. Take 11 days from November. 7. The final calculation will be: 5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1. 8. Now count it as Sunday 0 Monday 1. November 11 1991 was Monday. Hope that make sense! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Mario Sent: Monday, May 14, 2018 11:08 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? ok, how would a date like 11/11/1991 be handled?  Original Message  From: inamuddin khan [mailto:inamuddin09@gmail.com] Sent: Sunday, May 13, 2018 9:45 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Yes dear, you misunderstood the calculation. 1. Take 19 days from year 2001 to year 2019. 2. Take 4 days because from year 2001 to year 2019, there are 4 leap years. 3. Take 3 days each from January, March, May that will be 9 days. 4. Take 2 days each from April and June that will be 4. 5. Take 1 from February because the year 2020 will be leap year. 6. Take 8 days from July. 7. The total will be 45 not 36. The final calculation will be: 19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3. So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3. So July 8th 2020 will be Wednessday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Mario Sent: Monday, May 14, 2018 5:46 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? date is 7/8/2020 2020  1 = 2019. so start with 19. 4 leap years within those 19 years. so add a 4. starting from January 2020: January, March and May have 31 days. so add a 3. April and June have 30 days. so add a 2. add the 8 days of July. total is 36 divided by 7 (days in a week?) = 5.142 = 5.1. so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is something missing?  Original Message  From: Chris Chaffin [mailto:chaffin102468@gmail.com] Sent: Sunday, May 13, 2018 8:00 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hello Mario, As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year. Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days. Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September. And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25. Now step 4 is just the result from adding the numbers from step 3. Step 3 was the instructions, and step 4 is the calculation of step 3. Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week. For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on. Hope this has been helpful. Chris On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote: I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.  Original Message  From: Dave... [mailto:dgcarlson@sbcglobal.net] Sent: Saturday, May 12, 2018 7:33 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Clever and ingenious. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer  Original Message  From: inamuddin khan To: main@jfw.groups.io Sent: Saturday, May 12, 2018 16:26 Subject: Re: Where can I learn about formulas for Excel? Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date? Let me tell you how you can do it! Suppose your date is 12/25/2018. 1. Take 17 that is 17 years of 21st century. 2. Take 4 meaning that from year 1 to year 17, there are 4 leap years. 3. Take 3 from the months which have 31 days, 2 from the months which have 30 days and take 1 from the month which have 29 days. 4. From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December. 5. Now final calculation is: 17+4+18+8+25=72 divided by 7=10 remaining 2. 6. Now you can count them as, Sunday 0 Monday 1 and Tuesday 2. So December 25 2018 will be Tuesday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Sieghard Weitzel Sent: Saturday, May 12, 2018 9:49 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top). If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday. Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25. the day From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom Sent: Friday, May 11, 2018 6:18 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Hi, Following is a formula to calculate the day of the week from an input date. In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day. =TEXT(A4,"dddd") Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all. You’ll just need to experiment. HTH Tom From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor Sent: Saturday, 12 May 2018 9:31 AM To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hi. I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas. Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential. Thanks for any info. Have a blessed day and don’t work too hard. Kevin Minor and the amazing Jilly, Lexington, KY .


moderated
Re: Wire shark
charleseblack@...
There is something called tShark. This will give you information in textual
toggle quoted messageShow quoted text
format. Thanks.
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bissett, Tom Sent: Monday, May 14, 2018 10:08 AM To: main@jfw.groups.io Subject: Re: Wire shark Hi Nino, I haven't used wire shark for quite a few years. What I did find is that the information was displayed in two windows. You would locate an information line with the pc cursor and then you would have to use the jaws cursor to read the bottom pain that held all the related information. Not very practical. I found by exporting the information it was very readable only there was so much information it again was not very practical. Its colour scheme was all grey and you had to do custom colours for everything including menus. It can be used in a pinch but really not very useful on an ongoing basis. I don't know whether it has changed much since I had to use it. I don't know of any other tools like that. Regards Tom Bisset From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino Sent: Sunday, May 13, 2018 9:08 AM To: main@jfw.groups.io Subject: Wire shark Good morming" Happy mothers day to all those moms. I was wondering if anybody new if Jaws works with wireshark, if not what could be used in its place. Thank you.


moderated
Re: Where can I learn about formulas for Excel?
Dale Alton <blinkydale@...>
Thank you Dave. Once I went with remainder and not decimal, bingo bango
toggle quoted messageShow quoted text
Denver Dale
Original Message
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave... Sent: Sunday, May 13, 2018 9:00 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? remainder, not decimal, Dale. Use even division and note the remainder. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer  Original Message  From: "Dale Alton" <blinkydale@comcast.net> To: <main@jfw.groups.io> Sent: Sunday, May 13, 2018 19:33 Subject: Re: Where can I learn about formulas for Excel? I must be some thing wrong. Take November 23, 2018. The formula I come up with is: 17+4+6+23=68, 68/7=9.7. If Sunday is 0 and Monday is 1 where is 7? Denver Dale Original Message From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Chris Chaffin Sent: Sunday, May 13, 2018 6:00 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Hello Mario, As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year. Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days. Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September. And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25. Now step 4 is just the result from adding the numbers from step 3. Step 3 was the instructions, and step 4 is the calculation of step 3. Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week. For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on. Hope this has been helpful. Chris On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote:


moderated
Re: Where can I learn about formulas for Excel?
inamuddin khan
1. Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19. 2. Take 90 days from year 1901 to year 1990. 3. Take 22 days as leap years because from year 19901 to year 1990, there are 22 leap years. 4. Take 3 days each from January, March, May, July, August and October. 5. Take 2 days each from April, June and September. 6. Take 11 days from November. 7. The final calculation will be: 5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1. 8. Now count it as Sunday 0 Monday 1. November 11 1991 was Monday. Hope that make sense! With regards from Inamuddin with the Skype ID: Charlsdarwin1
Sent from Mail for Windows 10
From: Mario
Sent: Monday, May 14, 2018 11:08 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
ok, how would a date like 11/11/1991 be handled?
 Original Message  From: inamuddin khan [mailto:inamuddin09@...] Sent: Sunday, May 13, 2018 9:45 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Yes dear, you misunderstood the calculation. 1. Take 19 days from year 2001 to year 2019. 2. Take 4 days because from year 2001 to year 2019, there are 4 leap years. 3. Take 3 days each from January, March, May that will be 9 days. 4. Take 2 days each from April and June that will be 4. 5. Take 1 from February because the year 2020 will be leap year. 6. Take 8 days from July. 7. The total will be 45 not 36. The final calculation will be: 19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3. So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3. So July 8th 2020 will be Wednessday! With regards from Inamuddin with the Skype ID: Charlsdarwin1
Sent from Mail for Windows 10
From: Mario Sent: Monday, May 14, 2018 5:46 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
date is 7/8/2020 2020  1 = 2019. so start with 19. 4 leap years within those 19 years. so add a 4. starting from January 2020: January, March and May have 31 days. so add a 3. April and June have 30 days. so add a 2. add the 8 days of July. total is 36 divided by 7 (days in a week?) = 5.142 = 5.1. so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is something missing?
 Original Message  From: Chris Chaffin [mailto:chaffin102468@...] Sent: Sunday, May 13, 2018 8:00 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Hello Mario,
As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year.
Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days. Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September. And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25.
Now step 4 is just the result from adding the numbers from step 3. Step 3 was the instructions, and step 4 is the calculation of step 3.
Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week. For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on.
Hope this has been helpful.
Chris
On May 13, 2018, at 7:24 PM, Mario <mrb620@...> wrote:
I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.
 Original Message  From: Dave... [mailto:dgcarlson@...] Sent: Saturday, May 12, 2018 7:33 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Clever and ingenious.
Dave Oregonian, woodworker, Engineer, Musician, and Pioneer
 Original Message  From: inamuddin khan To: main@jfw.groups.io Sent: Saturday, May 12, 2018 16:26 Subject: Re: Where can I learn about formulas for Excel?
Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date?
Let me tell you how you can do it!
Suppose your date is 12/25/2018.
1.
Take 17 that is 17 years of 21st century.
2.
Take 4 meaning that from year 1 to year 17, there are 4 leap years.
3.
Take 3 from the months which have 31 days, 2 from the months which have 30 days and take 1 from the month which have 29 days.
4.
From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December.
5.
Now final calculation is:
17+4+18+8+25=72 divided by 7=10 remaining 2.
6.
Now you can count them as, Sunday 0 Monday 1 and Tuesday 2.
So December 25 2018 will be Tuesday!
With regards from Inamuddin with the Skype ID:
Charlsdarwin1
Sent from Mail for Windows 10
From: Sieghard Weitzel Sent: Saturday, May 12, 2018 9:49 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top).
If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday.
Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25.
the day
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom Sent: Friday, May 11, 2018 6:18 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel?
Hi,
Following is a formula to calculate the day of the week from an input date.
In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day.
=TEXT(A4,"dddd")
Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all. You’ll just need to experiment.
HTH
Tom
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor Sent: Saturday, 12 May 2018 9:31 AM To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel?
Hi.
I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.
Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.
Thanks for any info.
Have a blessed day and don’t work too hard.
Kevin Minor and the amazing Jilly, Lexington, KY
.


moderated
Re: start jaws automatically after log in
Steve Nutt
Hi,
The fix for this seems to be to set logon to always, as opposed to As Global Settings.
I have seen this problem too.
All the best
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: 11 May 2018 20:36 To: main@jfw.groups.io Subject: Re: start jaws automatically after log in
Very strange, Richard, yours and the other person’s report about this is the first I hear about it and I’m also part of the Jaws Beta where some people have been running the Insider/Beta builds of 1803 for a while. I myself have upgraded 5 computers (of 3 different makes and 5 different models with 1803 and have no issues with Jaws not speaking after logon. On the other hand on one of my work PC’s Jaws or Windows or whichever decided not to read the start menu or the content of the Settings app any more, I can go to Settings and it will say “System” as I tab into it from the search box, but then as I arrow around the highlight moves but Jaws is utterly silent. If I down arrow twice and press enter it does open “Personalisation” or if I press End and enter it goes into Update and Security, but once there and I tab it again reads/speaks nothing and the same happens in the start menu, visually it’s there but Jaws speaks nothing. It must be a weird glitch which wasn’t there after I first installed Windows 10 on that PC, but it persisted through several Jaws updates, I have uninstalled Jaws including shared components and user settings several times and even the Windows 1803 upgrade did not fix this. I am still talking to FS elevated support, but I have a feeling that nothing short of a complete reset or new installation of Windows would solve this and that is difficult since this PC happens to be our main register PC at my store and getting it all set up again is a major headache and would require my payment provider to connect and install their plugin to my point of sale software etc. It is however mostly a Jaws issue since if I unload Jaws and start Narrator it reads the Settings and start menu just fine. For now this is my workaround, I am not using that PC all that much anyways and if I use it then I don’t usually need the start menu and Jaws does work in the old control panel where I can access most things as well.
Regards, Sieghard
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
I have the same settings as Bill, but since the last Windows update to 1803, JAWS never talks after logon. I have to manually start JAWS. I'll be reporting this to Microsoft and VFO. Richard
“The secret is not to make your music louder, but to make the world quieter.”  Mitch Albom from The Magic Strings of Frankie Presto, page 1


moderated
Re: File find in windows 10 with jaws 2018, looking for content not the names of files
Steve Nutt
Yes, there is. See my previous message.
All the best
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: 09 May 2018 15:25 To: main@jfw.groups.io Subject: Re: File find in windows 10 with jaws 2018, looking for content not the names of files
Hi, David. I believe what John is asking is if there is a way to search for files in Windows 10 based on words contained inside files. This used to be possible in Windows XP, and I believe it is one thing we cannot now do since Windows 7. I miss this feature. I used to have a folder of recipes, and I could, for example, search for any of those text files that contain the word pistachio. This was nice, because it made it easy to find anything on the drive. It also used to be easier to change which drive was searched.
Bill White billwhite92701@...
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of David Bailes
Hi John, How can I find files in windows 10 by their content and not just their names. Thank you.


moderated
Re: File find in windows 10 with jaws 2018, looking for content not the names of files
Steve Nutt
Hi David,
Or you could type Doc: before your search term So if you were looking for “David”, and typed “doc:David”, it would only search in documents. No tabbing, just remembering three characters.
If you want to do the reverse and look for files by name, rather than content, then file: is your friend.
All the best
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of David Bailes
Hi John,


moderated
Re: Where can I learn about formulas for Excel?
Stan Bobbitt
Yes, and where do you come up with the numbers like 5 from 17, and 4 from 17.
toggle quoted messageShow quoted text
Stan B
Original Message
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Mario Sent: Sunday, May 13, 2018 7:25 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.  Original Message  From: Dave... [mailto:dgcarlson@sbcglobal.net] Sent: Saturday, May 12, 2018 7:33 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Clever and ingenious. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer  Original Message  From: inamuddin khan To: main@jfw.groups.io Sent: Saturday, May 12, 2018 16:26 Subject: Re: Where can I learn about formulas for Excel? Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date? Let me tell you how you can do it! Suppose your date is 12/25/2018. 1. Take 17 that is 17 years of 21st century. 2. Take 4 meaning that from year 1 to year 17, there are 4 leap years. 3. Take 3 from the months which have 31 days, 2 from the months which have 30 days and take 1 from the month which have 29 days. 4. From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December. 5. Now final calculation is: 17+4+18+8+25=72 divided by 7=10 remaining 2. 6. Now you can count them as, Sunday 0 Monday 1 and Tuesday 2. So December 25 2018 will be Tuesday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Sieghard Weitzel Sent: Saturday, May 12, 2018 9:49 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top). If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday. Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25. the day From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom Sent: Friday, May 11, 2018 6:18 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Hi, Following is a formula to calculate the day of the week from an input date. In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day. =TEXT(A4,"dddd") Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all. You’ll just need to experiment. HTH Tom From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor Sent: Saturday, 12 May 2018 9:31 AM To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hi. I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas. Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential. Thanks for any info. Have a blessed day and don’t work too hard. Kevin Minor and the amazing Jilly, Lexington, KY


moderated
Maria, please respond offlist
Sandra Streeter
Message for Maria Campbell:
Tried to get in touch with you re a nonJAWSrelated thing, but my message
bounced back, something to the effect that I wasn’t allowed to send to your
address. Ah, tech—can’t live with it, can’t live without! Hope to hear back
soon!
Sandra "Not everything that is faced can be changed, but nothing can be changed until it is faced." (James Baldwin)


moderated
Accessibility Development & Testing Resources
Hello All,
What follows will be posted on the JAWS for Windows, NVDA, and Windows 10 for Screen Reader Users groups on Groups.io. So anyone who might be participating on more than one of the above need only respond on a single one of those venues.
As some of you know, I have a bachelor's degree in computer science and well over a decade of professional experience (now somewhat distant) as a programmer, analyst, and database administrator. When I did my career switch, which turned out to be a semiswitch, to speech and language pathology I ended up having some focus on assistive technology in that realm and then expanded into blindness and lowvision areas when I came to work at the Virginia School for the Deaf and the Blind a few years back. Since then I've been doing quite a bit of freelance work for the Technology Tutor Network of the Virginia Department for the Blind and Visually Impaired (DBVI).
One of the things that's now coming to the fore is that accessibility is no longer an afterthought, but organizations are trying to design it in from the start. So, that leads to my first question: What are the standards, conventions, and other resources those of you involved in software development would point someone to who's trying to get a grasp on what is involved in "designing in accessibility" from the get go? There are probably resources that you all may know about that I certainly do not, at least not yet.
I have also been asked to assist with accessibility testing, which I am willing to do, but even I realize that as a sighted user of a screen reader that I am not, by far, the most skilled nor the most realistic model as far as this goes. It would seem that there is a huge business potential for accessibility testing by those who actually use screen reading software as their primary access method to the computer and to the internet. If anyone knows of either established organizations or individuals who are doing this sort of work freelance, would you please share this information with me either via private message or on the group?
I just received a call from the head of the DBVI Technology Tutor Network and we had a lengthy discussion of both of these things. I realized that I do not have the degree of expertise in either one of these arenas that many who participate on this group may have. I will pass along the information I receive unless a specific request that such not be shared is made.
Thanks in advance for your insights.
Brian  Windows 10 Home, 64Bit, Version 1803, Build 17134 Travel is fatal to prejudice, bigotry, and narrowmindedness, and many of our people need it sorely on these accounts. Broad, wholesome, charitable views of men and things cannot be acquired by vegetating in one little corner of the earth all one's lifetime. ~ Mark Twain


moderated
Re: Where can I learn about formulas for Excel?
Mario
ok, how would a date like 11/11/1991 be handled?
toggle quoted messageShow quoted text
 Original Message 
From: inamuddin khan [mailto:inamuddin09@gmail.com] Sent: Sunday, May 13, 2018 9:45 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Yes dear, you misunderstood the calculation. 1. Take 19 days from year 2001 to year 2019. 2. Take 4 days because from year 2001 to year 2019, there are 4 leap years. 3. Take 3 days each from January, March, May that will be 9 days. 4. Take 2 days each from April and June that will be 4. 5. Take 1 from February because the year 2020 will be leap year. 6. Take 8 days from July. 7. The total will be 45 not 36. The final calculation will be: 19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3. So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3. So July 8th 2020 will be Wednessday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Mario Sent: Monday, May 14, 2018 5:46 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? date is 7/8/2020 2020  1 = 2019. so start with 19. 4 leap years within those 19 years. so add a 4. starting from January 2020: January, March and May have 31 days. so add a 3. April and June have 30 days. so add a 2. add the 8 days of July. total is 36 divided by 7 (days in a week?) = 5.142 = 5.1. so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is something missing?  Original Message  From: Chris Chaffin [mailto:chaffin102468@gmail.com] Sent: Sunday, May 13, 2018 8:00 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hello Mario, As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year. Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days. Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September. And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25. Now step 4 is just the result from adding the numbers from step 3. Step 3 was the instructions, and step 4 is the calculation of step 3. Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week. For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on. Hope this has been helpful. Chris On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote: I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.  Original Message  From: Dave... [mailto:dgcarlson@sbcglobal.net] Sent: Saturday, May 12, 2018 7:33 PM EST To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Clever and ingenious. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer  Original Message  From: inamuddin khan To: main@jfw.groups.io Sent: Saturday, May 12, 2018 16:26 Subject: Re: Where can I learn about formulas for Excel? Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date? Let me tell you how you can do it! Suppose your date is 12/25/2018. 1. Take 17 that is 17 years of 21st century. 2. Take 4 meaning that from year 1 to year 17, there are 4 leap years. 3. Take 3 from the months which have 31 days, 2 from the months which have 30 days and take 1 from the month which have 29 days. 4. From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December. 5. Now final calculation is: 17+4+18+8+25=72 divided by 7=10 remaining 2. 6. Now you can count them as, Sunday 0 Monday 1 and Tuesday 2. So December 25 2018 will be Tuesday! With regards from Inamuddin with the Skype ID: Charlsdarwin1 Sent from Mail for Windows 10 From: Sieghard Weitzel Sent: Saturday, May 12, 2018 9:49 AM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top). If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday. Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25. the day From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom Sent: Friday, May 11, 2018 6:18 PM To: main@jfw.groups.io Subject: Re: Where can I learn about formulas for Excel? Hi, Following is a formula to calculate the day of the week from an input date. In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day. =TEXT(A4,"dddd") Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all. You’ll just need to experiment. HTH Tom From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor Sent: Saturday, 12 May 2018 9:31 AM To: main@jfw.groups.io Subject: Where can I learn about formulas for Excel? Hi. I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas. Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential. Thanks for any info. Have a blessed day and don’t work too hard. Kevin Minor and the amazing Jilly, Lexington, KY .


moderated
Re: Email inbox
Alternatively you can keep your Inbox clean by moving messages you have dealt with but want to keep into other folders, those which are not important get deleted and only those you still want to reply to or need for something else in the short term stay in the Inbox. I think that is what an “Inbox” is supposed to be, a temporary place to keep incoming emails until you no longer need them or file them I n their proper place. After all, you don’t throw all your paper mail into a big box and leave it there.
Regards, Sieghard
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Bill White
Sent: Monday, May 14, 2018 8:30 AM To: main@jfw.groups.io Subject: Re: Email inbox
Hi, Nino. If I have an email which I know I will want to act on in the future, and know it may be difficult to find, here’s what I do. I use F12 to save the email as a file. Once it saves, the name resembles the subject line, and it is usually saved as a file in Documents with an .msg extension. If you click on the file, it opens outlook, and you are in the body of the email you saved. You can do all the things you can normally do with an email, including, reply, forward, etc.
Bill White
From:
main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Nino Dagostino
Hi:
I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.
Is there a way to move that message further up in the list of emails?
I hope I explained it properly.


moderated
Re: Email inbox
Bill White <billwhite92701@...>
Hi, Nino. If I have an email which I know I will want to act on in the future, and know it may be difficult to find, here’s what I do. I use F12 to save the email as a file. Once it saves, the name resembles the subject line, and it is usually saved as a file in Documents with an .msg extension. If you click on the file, it opens outlook, and you are in the body of the email you saved. You can do all the things you can normally do with an email, including, reply, forward, etc.
Bill White billwhite92701@...
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Monday, May 14, 2018 4:24 AM To: main@jfw.groups.io Subject: Email inbox
Hi:
I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.
Is there a way to move that message further up in the list of emails?
I hope I explained it properly.


moderated
Re: Casper
netbat66
version 8 does and is the most accessible.
toggle quoted messageShow quoted text
Original Message
From: Nino Dagostino Sent: Monday, May 14, 2018 4:11 AM To: main@jfw.groups.io Subject: Casper Hi: Will the older versions of Casper work in windows10? Thanks


moderated
Re: Email inbox
Nino Dagostino
Hi:
That’s a good idea, thanks
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of paul lemm
Sent: Monday, May 14, 2018 10:19 AM To: main@jfw.groups.io Subject: Re: Email inbox
Hi,
I’m not sure that’s possible since most email clients sort emails in a specific order (usually by date received), however, although this isn’t a perfect solution by anymeans, as a work around you can just forward the email to yourself, this way it will show as a new message at the top of your inbox and then you could keep that copy an delete the older one.
Hope this helps
Paul
Paul From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Hi:
I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.
Is there a way to move that message further up in the list of emails?
I hope I explained it properly.


moderated
Re: Using JAWS to Resume a Download from BARD
Dan Longmore
I don’t believe that BARD, except perhaps BARD express, will allow you to pause and resume. You need to re start the download. Dan
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Miller
Sent: Monday, May 14, 2018 12:00 AM To: jfw@groups.io Subject: Using JAWS to Resume a Download from BARD
Dear Listers:
When a download I am trying to make from the BARD web site is interrupted, I try to get it to resume by finding the Resume button and using a left mouse click. But instead of picking up where the download left off, it starts it all over again. Is there a way using JAWS that you can resume an interrupted download where the download will resume from where it left off?
Rick Miller


moderated
Re: Email inbox
paul lemm
Hi,
I’m not sure that’s possible since most email clients sort emails in a specific order (usually by date received), however, although this isn’t a perfect solution by anymeans, as a work around you can just forward the email to yourself, this way it will show as a new message at the top of your inbox and then you could keep that copy an delete the older one.
Hope this helps
Paul
Paul
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: 14 May 2018 12:24 To: main@jfw.groups.io Subject: Email inbox
Hi:
I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.
Is there a way to move that message further up in the list of emails?
I hope I explained it properly.


moderated
Re: Wire shark
Bissett, Tom <tom.bissett@...>
Hi Nino, I haven’t used wire shark for quite a few years. What I did find is that the information was displayed in two windows. You would locate an information line with the pc cursor and then you would have to use the jaws cursor to read the bottom pain that held all the related information. Not very practical. I found by exporting the information it was very readable only there was so much information it again was not very practical. Its colour scheme was all grey and you had to do custom colours for everything including menus. It can be used in a pinch but really not very useful on an ongoing basis. I don’t know whether it has changed much since I had to use it. I don’t know of any other tools like that. Regards Tom Bisset
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Nino Dagostino
Sent: Sunday, May 13, 2018 9:08 AM To: main@jfw.groups.io Subject: Wire shark
Good morming”
Happy mothers day to all those moms.
I was wondering if anybody new if Jaws works with wireshark, if not what could be used in its place.
Thank you.

