Computer Support Forum

X1 (2017) Release Dates?

Question: X1 (2017) Release Dates?

Hey there! I'm getting really impatient and Lenovo Germany couldn't answer me: When is the new Thinkpad X-Series being released? Some googleing made me think it's February 2017, but by now i doubt that, February is almost over. I know this isn't a tech question by all means but I'm new to Lenovo and i would like to get some information about it. Please, i'm in desperate need of a new Laptop and if the new Yoga X1 wouldn't releas in time i would just go and buy the old one. Thank you in advance!M

Relevance 100%
Preferred Solution: X1 (2017) Release Dates?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: X1 (2017) Release Dates?

Oh, sorry for bothering but i got one additional question: Does anyone know if new products immediately become part of the Lenovo Campus deals?

1 more replies
Relevance 64.37%
Question: S50 Release dates

Hi Does Anyone know when the specific release dates for these models of S50s are? Thinkcentre 8183-Z7YThinkcentre 8183-VPVThinkcentre 8417-NGRThinkcentre 8417-LGV Thanks in advance CB

More replies
Relevance 63.96%

Really like the Y560 it would be good if we could get a release date for it in the UK ?Anybody know when it is due to be released ?

Answer:Y560 UK Release Dates ?

better to ask lenovo support line.
call 08082342923 for uk.

4 more replies
Relevance 63.96%

Source - When will you get Windows 7 RTM? - Windows 7 Team Blog - The Windows Blog

OEMs - 2 days after official RTM.
Connect-MSDN-Technet - August 6th
VLS w SA - August 7th
VLS wo SA - 2 Weeks After above
MPN - August 16th
MAPS - August 23rd

I expect an official RTM announcement on 7-23-2009 (Thursday)

Answer:Official RTM Release Dates

  
Quote: Originally Posted by xendrome


Source - When will you get Windows 7 RTM? - Windows 7 Team Blog - The Windows Blog

OEMs - 2 days after official RTM.
Connect-MSDN-Technet - August 6th
VLS w SA - August 7th
VLS wo SA - 2 Weeks After above
MPN - August 16th
MAPS - August 23rd

I expect an official RTM announcement on 7-23-2009 (Thursday)


Even though technet folks will have to wait for august...when it hits OEM than we will have it

9 more replies
Relevance 63.96%

Anyone???

Anyone???

Beuller???

Does anyone know what the release dates are for the 5 versions of Vista that are allegedly coming out???
 

Answer:Vista Release Dates

Last official word from MS is January 2007 but Gartner speculates later in Q1 2007. Enjoy speculating like the rest of us.
 

2 more replies
Relevance 63.14%

i want netbackup version release dates. can anybody help me out?

Answer:netbackup versions release dates

Why not email them?1/3 of highway deaths are caused by drunks. The rest are by people who can't drive any better than a drunk.

2 more replies
Relevance 63.14%

does anyone know them? thanx

Answer:Windows XP 64bit release dates

Arn't they today, or is it the 22nd of next month?

Hrm, w/e

1 more replies
Relevance 63.14%

When is the other set of penryn processors coming out,is it coming out in january as it suppose to?cause i want to get the 2.8 quad which is for 530.
 

Answer:Intel penryn release dates?

Planned for Januari 20th I think.
 

1 more replies
Relevance 63.14%

A French website, PC Inpact, has posted the official Microsoft product change request forms for Vista SP1 and Windows XP SP3. So just when do our friends from France say Microsoft is planning on releasing our little Service Pack friends? Well, according to them, we will be seeing Vista SP1 a little earlier than previously anticipated:

Windows Vista SP1: February 18th or 19th
Windows XP SP3: March 23rd or 24th
Product Change Request Forms: Vista SP1 | XP SP3


Windows Vista SP1 & XP SP3 Release Dates :

Answer:Windows Vista SP1 & XP SP3 Release Dates

Well, according to this article, the Vista SP1 release is being delayed another 6 weeks. I seem to remember a long time ago arguing with a certain person who is now a moderator about just that. I said I'll believe it's coming out in Q1 of '08 when I see it. And now they're already starting on the possibly long path of delays.

I'll believe it's only going to be a 6 week delay when I see it.

But I will say, at least they're trying to get things to work right.

3 more replies
Relevance 63.14%

Hi,
I found very nice benchmark list of graphic cards here on the forum.
What I'm looking for is release dates, does anybody know where to find this information at one place?
I'm interested mailny in nVidia and ATI chips, that should by enough.
Thanks.

Answer:Graphic cards release dates

Release dates for future cards or cards that have already been released?

7 more replies
Relevance 63.14%

Good Morning, I'm heavily considering switching from iOS to Windows. I have always heard great things from everyone who has Windows phones.
I would consider myself tech savvy but only when it comes to iOS because that's all that I'm used to. I know iOS devices are announced in September. Is there a date when Windows phones are announced or released? If I'm looking to switch, should I wait a little longer for a new device or are the latest out already?
I'm on AT&T and live in the US. So LTE would be a requirement.
Any help on this matter would be greatly appreciated.

Answer:Windows Phone release dates

I switched from an iPhone 4 to a lumia 925. On the hardware front, it is gorgeus, but on the software front, I am a bit disappointed. This is personal opinion, but I would not persuade you to do it.

3 more replies
Relevance 62.73%

Highly recommended if you use Rufus on Windows 10 Creators Update

Rufus is a utility that helps format and create bootable USB flash drives, such as USB keys/pendrives, memory sticks, etc.

you need to create USB installation media from bootable ISOs (Windows, Linux, UEFI, etc.)
you need to work on a system that doesn't have an OS installed
you need to flash a BIOS or other firmware from DOS
you want to run a low-level utility
Despite its small size, Rufus provides everything you need!

Get Rufus: Index of /downloads

Changelog:

Preserve 'GPT for UEFI' option if the user changed it before selecting an ISO
Fix unwanted notification sound when closing with the X button
Fix inability to restore the minimized application after a popup is displayed
Fix an issue when trying to install Syslinux/NTFS twice in a row
Work around Microsoft's inconsistent casing of device IDs during device enumeration
Work around Microsoft's aggressive locking of partitions in Windows 10 Creators Update
Restrict write sharing permissions when accessing a device
Update libcdio and GRUB 2.0 to latest

 

Answer:Rufus 2.13 - 6th April 2017 release

Thank you.
Never used it before but i'll give it a go soon!
 

6 more replies
Relevance 62.32%

Hi all, I am trying to assist my organization with its planning capabilities by finding the lifecycle dates for the products used in our system. By lifecycle dates, I mean the dates when a given product stops being sold by the manufacturer (typically called "end of life") and when the manufacturer ceases to provide service on the product (often referred to as "end of service life"). Cisco, for instance, announces these dates when they become available, and they update their support notes for individual products after they have been made public. Does Acer have a similar policy, and, if so, where can I locate this information? Thanks, _______________________________________________________________________Josh FieroIT Asset Manager | Infrastructure Services Capgemini USA | Austin, TXwww.capgemini.comPeople matter, results count._______________________________________________________________________ 

Answer:Does Acer release lifecycle dates for its products...

This page has a worksheet that might help you. Scrill down.https://support.google.com/chrome/a/answer/6220366?hl=en 

1 more replies
Relevance 62.32%

Hi all, I am trying to assist my organization with its planning capabilities by finding the lifecycle dates for the products used in our system. By lifecycle dates, I mean the dates when a given product stops being sold by the manufacturer (typically called "end of life") and when the manufacturer ceases to provide service on the product (often referred to as "end of service life"). Cisco, for instance, announces these dates when they become available, and they update their support notes for individual products after they have been made public. Does Acer have a similar policy, and, if so, where can I locate this information? Thanks, _______________________________________________________________________Josh FieroIT Asset Manager | Infrastructure Services Capgemini USA | Austin, TXwww.capgemini.comPeople matter, results count._______________________________________________________________________ 

Answer:Does Acer release lifecycle dates for its products...

This page has a worksheet that might help you. Scrill down.https://support.google.com/chrome/a/answer/6220366?hl=en 

1 more replies
Relevance 61.91%

Hi there, I?m very interested in purchasing the new X1 carbon, but with the 2k screen. I can?t find any official statement about a release date appart from ?summer of 2017?. Did anyone know more about it? Have a nice day.

Answer:Carbon X1 2017 WQHD release date?

When I last asked their online chat support (last week), they said they simply "did not know".  This is in spite of the X1C product page saying WQHD would be available in June.  I'm a big Thinkpad fan - my X220 is still running strong and I got a Thinkpad Yoga 14 last fall which I sold only bc I was so amazed when I saw the release of the X1C 5th Gen in January.  But I have to say I am very very disappointed in Lenovo.  Almost six months after boasting the WQHD specs it is still not available with no estimate on timing either.  This is one of the largest companies in the world yet they can't seem to have an efficient supply chain.  No wonder HP has snatched the #1 PC maker crown away from Lenovo...

2 more replies
Relevance 61.91%

February 14 2017 security update release
Our top priority is to provide the best possible experience for customers in maintaining and protecting their systems. This month, we discovered a last minute issue that could impact some customers and was not resolved in time for our planned updates today.
After considering all options, we made the decision to delay this month?s updates. We apologize for any inconvenience caused by this change to the existing plan.
https://blogs.technet.microsoft.com/msrc/2017/02/14/february-2017-security-update-release/
 

More replies
Relevance 61.91%

Hi. I relly want to buy t460s, but I just wondering if the price for it will go down after 2017 thinkpad release. What's your plan, guys?

More replies
Relevance 61.91%

Source: Anti-virus4U.com Blog: Norton Security Products Launch Updates

Symantec will launch new version (Rehash) of Norton Security (Cloud-Based Antivirus) on October 5
?We at Norton are constantly striving to provide the most comprehensive and responsive set of products for our customers. To that end, we are proud to announce a revitalization of our main Norton product line. See below for our current products and what their new names in English speaking markets will be after this launch.?

? Norton Security Standard (formerly Norton Security for 1 Device)
? Norton Security Deluxe (formerly Norton Security)
? Norton Security Premium (formerly Norton Security with Backup)

*The projected launch dates are October 5th in the US, Canada, all Latin American countries. October 19th in Australia/New Zealand, and rest of the globe.
 

Answer:Norton Security Products Updates and Release Dates

:/ they focus too much on cloud, i wonder if they want to be the next qihoo... where are signatures improvements?... is not a good idea to use these products in latin american countries.
 

13 more replies
Relevance 61.91%

My contract is up in a few weeks and I am trying to figure out if I should go with the HTC One (M8) now or if there's a new one coming in the next 6 weeks I may wait.
Any help is greatly appreciated.

Answer:What are the expected release dates of upcoming Win8 phones?

MWC is the best bet now. But I doubt we will see a new flagship...

2 more replies
Relevance 61.5%

when will Panda Global Protection 2017 beta ?
 

Answer:Panda Global Protection 2017 beta release?

We are in 2016! That will be their New version for 2017
 

2 more replies
Relevance 61.09%

I have an upgrade available and I want to get the latest and greatest Windows Phone for AT&T. I have seen a HTC and Samsung Windows Phone at a Verizon store. Unfortunately, I have AT&T. I have been searching the internet way too much looking for the newest Windows Phones.
My question is, can someone breakdown the best current Windows phones, upcoming Windows Phones and dates. I don't mind my current Nokia 520, which I got when I broke my HTC Windows Phone. However, I do want a new phone and I'm a big fan of this OS. Any info is much appreciated!

Answer:What are the Windows Phone for AT&T Release Dates and Rumors for Fall 2014?

The flagship for AT&T is currently the L1520, it is already released and you can see one in the store right now. As for future devices, the HTC One W8 has yet to break away from Verizon exclusivity and their is no guarranteed day for it to come over to AT&T. You also have the L830 coming which would be a nice upgrade from the L520 if you want something recently released. According to this article, Nokia Lumia 830, 735, 730 Release Date, Specs: AT&T, Sprint, Verizon, T-Mobile | Gospelherald.com , the L830 has yet to receive an official release date but I'm betting on it releasing sometime before or at the same time the HTC One W8 debuts.

2 more replies
Relevance 59.86%

For the past ten years, Intel has successfully managed to shrink the manufacturing process for their CPUs every two years. However, with each shrink of the process node there are complications to deal with, which is why Intel has announced...

Read more
 

Answer:Intel delays 10nm process to 2017, will release a third 14nm CPU family

I think this will be better in the long run. maybe amd will play catch up and cpu prices will become more affordable.
 

12 more replies
Relevance 59.45%

Hi,
Im interested in buying one of the new Dell Inspiron 7566 15" gaming laptops with Kaby Lake processors, I've heard they became available in the USA today, does anyone know when we might see these released over here in the UK?
Thanks,
James

More replies
Relevance 57.81%

Hi ,  I am trying to download the BIOS update for X1 carbon 4th gen 20FB and i couldnt find that in this page. Can you please difrect me where to get it ?  https://support.lenovo.com/us/en/solutions/LEN-18282 Thanks,Ramesh

Answer:LEN-18282: Reading Privileged Memory with a Side Channel CVE-2017-5753, CVE-2017-5715, CVE-2017-575

Welcome to the CommunityThe BIOS update is published on the laptop' download pagehttps://pcsupport.lenovo.com/us/en/products/laptops-and-netbooks/thinkpad-x-series-laptops/thinkpad-...
 
UPD
The link to the BIOS update is present on the page you've mentioned, unfortunately without laptop' MT code or x1 Carbon its generation #:
 
ThinkPad X1 Carbon, X1 Yoga - Affected - N1FET59W - https://pcsupport.lenovo.com/downloads/DS111756 - 1/7/2018
 

1 more replies
Relevance 53.71%

Hi everyone, i have quite a few questions so i'll post separate threads rather than pollute one thread. I'm wanting to get something a lot better than windows defender. Comcast is my ISP so i can get NIS for free. As most of you are aware of Norton hasn't been doing a great job these days. There has been multiple vulnerabilities in its products that actually decreases the security of windows. Still NIS still does a pretty good job of scoring pretty well in the various test in terms of protection. I was thinking on going with either bitdefender or KIS but of course i would have to pay for those. If you were me would opt for NIS because its still pretty dang good and worlds better than bit defender or would you opt for one of the better products like KIS or bitdefender?
 

Answer:Kaspersky IS 2017 vs Norton IS 2017 vs Bitdefender IS 2017

bitdefender free+ CF and SAP i think will be good
 

11 more replies
Relevance 52.89%

As Mozilla launched the first Firefox 5 Aurora testing Build, the company also made public the release deadlines of Firefox 4.0?s successor as well as of future iterations of the open source browser.

Firefox 5 is now available for download through the Aurora Channel, and is the first version of Firefox to make its debut through this new Channel introduced as Mozilla moved to accelerate dramatically the release pace of new iterations.

According to the open source browser vendor, Firefox 5, Firefox 6 and Firefox 7 will all be wrapped up and offered to end users in 2011.Click to expand...

Link
 

Answer:Firefox 5 June 21, Firefox 6 August 8, Firefox 7 September 27 Release Channel Dates

Nice, I would love to see all those versions, can't wait until June!
 

1 more replies
Relevance 49.2%

Hi – I need some help.

I have a log that lists the start date and end date of my fleet of cars. I want to be able to tell how many cars we had in our fleet on any day (and then be able to average out the number of vehicles in a month)

What I have is two columns with the first containing the start date of the car and the second containing the termination date of the car.

Example

Code:

21/04/2006 20/04/2010
21/04/2006 20/04/2010
27/04/2006 26/04/2010
28/04/2006 27/04/2010
1/05/2006 28/04/2010
3/05/2006 29/04/2010
3/05/2006 30/04/2010
12/05/2006 11/05/2010
17/05/2006 1/05/2010

On another sheet I have dates starting 1/1/2003 incrementing by a day up to 2013. What I am looking for is a way to count how many times each of the dates falls between (or on) the date in each of the ranges.
EG in the example data above 5/5/2006 = 7, 6/5/2006 = 7, ..., 12/5/2006 = 8. (I hope! )

Note - I am using dates in the format DD/MM/YYYY

Hope you can help!
 

Answer:Solved: Counting number of times dates occure between range of dates

8 more replies
Relevance 48.38%

Good evening everyone. Thanks for your access to this thread. I hope you to read and answer for this question.

I want to ask everyone that which software should I use for keeping security of my PC.

Now I am using Bitdefender Total Security 2017 as main anti-malware soft on my main desktop PC.
And also I was using F-secure SAFE as anti-malware soft on my PC until last week.

Yesterday, I heard that new Avast Antivirus 2017 was released, and new Avast Free is including behaviour scanning system.

I am having trouble deciding which software should I use as anti-malware soft.
Please tell me about your recommend.

I think that...

?Protection features
Better : Bitdefender 2017 > F-secure SAFE > Avast Free 2017

?Performance and speed
Lighter : Avast Free 2017 > F-secure SAFE > Bitdefender 2017

?the risk of false positive trouble
Bigger risk : F-secure SAFE > Avast Free 2017 > Bitdefender 2017

?SSL (HTTPS) Scanning is enable without fake SSL certificate to browser
Unnecessary fake certificate : Avast Free, F-secure
Need fake certificate : Bitdefender Total

F-secure SAFE is the very nice solution as protection from malwares and keeping speedy PC. But it is having big risk of false positive ratings; especially the website blocking is not good with many many false positive ratings. And, sometimes slow down my PC.

Bitdefender Total Security 2017 is the best solution as protection from malwares. This software is providing users very nice anti-malware solu... Read more

Answer:Avast Free 2017 vs F-secure SAFE vs Bitdefender Total Security 2017

Quick question, why Bitdefender Total Protection? Do you need ALL those additional features, or looking for an Antivirus only, because there are Bitdefender Antivirus Plus and Free versions.

What about other protection software like Emsisoft Anti-Malware/Internet Security or ESET Nod32 Antivirus/Internet Security?
 

11 more replies
Relevance 48.38%

I have no idea if this is even possible, but I would like to create a spreadsheet that auto-populates a series of dates based on one date that the user enters. Let's say I have a goal date to complete a project, and for every project I work on, something needs to happen 6 weeks prior to the goal date, another thing needs to happen 4 weeks prior to the goal date, and something else needs to happen 1 week and 5 days before the goal date. I would like to set up 4 cells in Excel: one for the goal date, and three for the various things that need to happen leading up to that goal date. I would like to be able to enter the goal date into the main cell and have the other three cells auto-populate with the correct date based on what I enter in the goal date. For example, if I enter a goal date of 11/01/2016, I would like the other three cells to automatically populate themselves with: 09/20/2016 (6 weeks prior), 10/04/2016 (4 weeks prior), and 10/20/2016 (1 week and 5 days prior). Is this possible? Can Excel return dates in that way?

Answer:How can I auto-populate dates in Excel based on other dates?

Sure, it's easy. Excel internally stores Dates and Times as numbers. Each day is a whole number and time is the decimal portion of that day. See here for a pretty good explanation of how Excel deals with Dates and Times as well as links to all the various Date and Time functions that Excel offers:http://www.cpearson.com/excel/datet...As for your question, simply subtract the number of Days required from the cell with the Goal Date.With 11/01/2016 in A1, use this to return 9/20/2016:=A1-42(42 is 6*7, or 6 weeks.)I'll leave the other two formulas to you. ;-)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 48.38%

Once again I'm reaching out to the TSG forums for help. I have a column (bid request date) and another column (bid approved date). In my pivot table I have a count of these by my team members. # of Bids Submitted and # of Bids Approved and I want to add another column into the pivot table, "Approval rate" which divides the # of Approved by # of submitted. Is there an easy way to do this in a pivot table?
 

More replies
Relevance 48.38%

College Football Picks 2017-2018 Season Charlotte at Eastern Michigan Eagles September 01, 2017 @ 06:30pm

Charlotte at Eastern Michigan Eagles

COMPUTER PREDICTIONS STRAIGHT-UP

TEAM SCORE PERCENTAGE TO WIN GAME
Charlotte 22.903 26%
Eastern Michigan Eagles 30.181 74%

COMPUTER PREDICTIONS AGAINST THE SPREAD

TEAM SPREAD TOTAL
Charlotte +14.0 59.5 over
Eastern Michigan Eagles -14.0 59.5 under

Get full analysis, detailed write-ups, and official picks at goo.gl/Xf3NiR
 

More replies
Relevance 48.38%

Hello, Guys!
I'm new on this forum but I Really Really like this good Forum
So I had Emsisoft for couple of months now
But Recently I've switched over to Avast Premier Beacuse I've never used Avast before So I wanted to try It out
But now I'm without any AV As I do not know what to Install Avast or Emsisoft!
I have licences for both So thats not the problem
Thanks In Advance And btw This forum really nice.
 

Answer:Avast Premier 2017 Vs Emsisoft Internet Security 2017

Both have excellent protection functions, but certainly they are two different security solutions.
I think the choice of one or the other one is really subjective, I've used Emsisoft for many years and it is my first choice
 

46 more replies
Relevance 48.38%

My BD sub expires soon. Trying to decide whether I should switch to Norton 2017. It's my understanding that Norton is no longer the grand POS it used to be.

What say you?
 

More replies
Relevance 47.97%

A couple of years ago I moved myself and some of the fam from Apple Everything to Windows 10. Yesterday however, I bought an new 2017 iPad. I really love the Surface devices, so why?
LEAVING THE PLATFORM BECAUSE OF WINDOWS MOBILE
First, because Microsoft are no longer supporting the phones that are in our house, we are being forced from that platform. So rather than living and breathing completely and happily inside the Microsoft ecosystem, I am now forced to diversify and go elsewhere. This really is a big deal, and changes my thinking from the unthinkable (leaving the MS ecosystem) to the possible (shifting back towards Apple). That being the case, why should I then buy a Microsoft Surface tablet (I was planning to buying a new Surface Pro M3) when I an now FORCED to be open to Apple and Android?
EASE OF MOVING PLATFORMS
Second, Microsoft have made my leap back to Apple so easy, because they have done what Apple and Google have refused to do, which is to make their software available on the others' platforms. Thus the transition to iPad is easy. For example, Word and PowerPoint are effectively free (via my 365 account that I will not be renewing at full cost next time; I will use the academic version which costs me almost nothing). Outlook on iPad is a great app (better than on PC platform). Lots of other apps that Microsoft that I use are also really nice on iPad (e.g. Wunderlist) and made the transition really simple and clean.
FACEBOOK
Third, the Facebook app on iPad is ... Read more

Answer:I did the unthinkable and chose a 2017 iPad over a 2017 Surface Pro M3

Microsoft are no longer supporting the phones that are in our house, we are being forced from that platform
Can't make sense of that. Presumably you have really old windows phones that no longer get updates?
And what does that have to do with what tablet you use? Windows has timeline, cloud clipboard and a whole host of platform agnostic features coming this fall, so Windows will play nice with android or ios (better than those OSes play with any other).
You don't even need your tablet, desktop and phone to be the same platform. You just need the same services, which for MSFT, exist on every platform.

1 more replies
Relevance 47.56%

Hi there I tried linking my serial number and product number of my laptops  with my hp passport, but that does not seem to to work. The warranty checker start date november 2014 but we bought them in october 2015, so we are a year out. How do I update these, and am I able to link them to this hp passport account. Thanks for your time. All the best Matt

Answer:Warranty dates do not tally with my purchase dates

Hi melton , In this to get you warranty to be update please do contact the HP support line of your country with the Proof of purchase with the serial number on it . So that they would work on it and get it updated . HP Worldwide Telephone Numbers  http://h10032.www1.hp.com/ctg/Manual/c00047049.pdf Also as you have the the passport account  you can raise a request throught the support case management . r-K //Click on Kudos and Accept as Solution if my reply was helpful and answered your question// I am an HP employee!!

1 more replies
Relevance 45.92%

Hi there,

I have a whole column of dates in this format in my table: 20080602

I want my macro to change the format of the dates from this 8-digit number string, into a date format that Excel can recognize (6/02/2008). Once the dates are re-formatted, I then want to have the macro select rows with dates that are up to four days of age only for the new report.

Here is what I've got to format the dates. When I run it, the macro stops at this point and tells me to debug, telling me I have a 'syntax error'. A what?

Columns("A:A").Select
Selection.Format = Date(left(a1,4), mid(a1,3,2), right((a1,2))
Once I do get the dates right, how would I get it to select dates that are up to four business days in age only? This is what I thought I should use, but it doesn't work:

Range("A1").Select
Selection.Format >=today()-4

Thanks!
 

Answer:formatting dates and selecting dates by age in vba?

I don't think that you can do what you want using the Format function as you have tried to do it. You are on the right lines with the Left, Mid and Right though.
in another column put this in a Cell on the same row as A1
=mid(a1,5,2) & "/" & right(a1, 2) & "/" & left(a1,4)
If that gives you the correct "look" then Drag that formula down the rest of the rows with Dates in. Then copy the whole Range of new look dates and Paste Special>Values over the first cell in that Range or in a new column and you should now have your Dates.
In the next column type in the first cell
= if(today() - Celladdress <= 4, "Yes", "")
Where celladdress is the cell with you first "Proper" Date.
This will place a "yes" in the column wherever the date is within 4 Days.
If this is not satisfacory and you really need to have a Macro to do this you can use the same "Formatting" in the Macro, but you will require a "For/Next or For/Each loop" to do it.
 

2 more replies
Relevance 45.92%

Hi, I am trying to create an IF nested formula for this case: If it is less than X date = Over Retained and Not Over Retained if it there is no date, or the date is greater than X date.

Answer:If formula question with dates and no dates

We could use a little more information.1 - You haven't told us what you want to happen if the cell equals the date.2 - When you say there is "no date", what is actually in the cell? Is it blank or text or something else?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

4 more replies
Relevance 45.92%

Bios shows date as 1/17/2017 and laptop shows it as 17/1/2017 I can find no way of changing it.
Is this normal and nothing to worry about.

Answer:Should BIOS dates be the same as laptop dates

Looks as if the BIOS is displaying dates in US format MM/DD/YYYY rather than UK format DD/MM/YYYY, so it is showing the same date, just in an alternative format.
Not being able to see any occasion where you need to look in the BIOS to check the date it shouldn't really be a problem

2 more replies
Relevance 45.92%

For example. Col Start_date 3/15/2011 and Col End_date 3/18/2011.I would like to search for the 3/16/2011

Answer:find dates between two dates in access

You could create a simple input query that prompts for the date you're looking for.

2 more replies
Relevance 45.1%

Hello,
I'm trying to push out the update for the CVE-2017-11937 and CVE-2017-11940 vulnerabilities through WSUS but I can't find the KB# for either of them. Anyone know what KB# these two have?
Thanks!

More replies
Relevance 45.1%

Hi guys
Wich do you perfer?
 

Answer:avast 2017 or F secure 2017?

Avast has nicer user interface and more features besides that everything else is pretty similar.
 

6 more replies
Relevance 45.1%

Has anyone tried the new NVIDIA Quadro Notebook Driver Release 3310.70 WHQL (Release Date:2012.12.10) yet? http://www.nvidia.com/object/quadro-notebook-win8-win7-winvista-64bit-310.70-whql-driver.html RELEASE HIGHLIGHTS :New in Release 310.70:ODE Driver WHQLThe R310 drivers are the fourth ?Optimal Drivers for Enterprise?, a release dedicated to relatively long term stability for ISV certification, OEMs, and Enterprise customers. OepnGL 4.3 support on Kepler and Fermi series GPUs.Workstation Features ? Mosaic and SyncMosaic topology configurations are now preserved across driver over installs for 310 and up.Sync settings will persist across driver over install with 310 drivers and up.NVWMI 2.9Workstation: Windows 7 and laterImproves performance of the profile frameworkImplements saving on an nView desktop profile in the method ProfileManager::saveDesktopProfileSupports saving a display EDID in the method Display::saveEDIDNVIDIA Control PanelThe NVIDIA Control Panel Access Control features allow workstation enterprise administrators to control which features of the NVIDIA Control Panel are available to users.Manage 3D Settings Category: NVIDIA Driver Controlled Mode ? Windows 7 and laterNew mode that causes the GPU to automatically apply the best performance and image quality settings when using features such as Mosaic, SDI, and G-Sync/Quadro Sync.Display-> Change Resolution Page: Select Displays option ? Windows 7 and laterNew option to apply custom... Read more

Answer:Quadro Notebook Driver Release 310.70 WHQL (Release Date: 2012.12.10)

You first. 

4 more replies
Relevance 44.69%

GFI Software is happy to announce the general availability of Service Release 2 for VIPRE 2012. This Service Release is a free update, applicable to all users of VIPRE Antivirus 2012 and VIPRE Internet Security 2012.

We have improved the performance of VIPRE and resolved several customer-reported issues in this release. Service Release 2 contains a number of improvements to the firewall and web filter drivers, the VIPRE service, and threat engine. Because it is a service release, no new features were introduced.

Highlights of this release:

Fixed issues where the firewall or web filter drivers would hang
Fixed instances where browsing the internet, or using uTorrent, with web filtering turned on would cause a system hang
Resolve issues with Active Protection
Resolve an issue where incompatibilities with other drivers would result in Windows shutting down with STOP error
Fixed a service crash during product registration on certain machines
Now correctly reports incompatible programs on computers running 64-bit versions of Windows


How to Get Service Release 2:

VIPRE 2012 will automatically check for the update and prompt you to install. GFI Software is making available Service Release 2 to all users of VIPRE 2012 on a ?metered? basis. This means some customers will receive the update sooner than others. If you?d like to manually update immediately, you can find instructions here:

http://kb.gfi.com/articles/SkyNet... Read more

Answer:VIPRE Antivirus 2012 - Services Release 2 - Release Announcement

I am interested to see this:
Resolve issues with Active Protection
Fixed instances where browsing the internet, or using uTorrent, with web filtering turned on would cause a system hang
 

8 more replies
Relevance 44.69%

I am in need of a program to be able to look up MP3s on an online database and return the ORIGINAL YEAR the song was released as well as the ORIGINAL ALBUM. I don't want Greatest Hits or Compilations. So say for instance, I have an MP3 titled "Def Leppard - Photograph". I don't want the program to return the greatest hits albums that this song was on and the year those greatest hits albums were released, I only want to see "1983" and "Pyromania".

Does anyone have any idea where I can find something like this?
 

Answer:Taggin MP3s with Original Release Year and Release Album

Déjà Vu all over again.

http://forums.techguy.org/all-other-software/871899-music-tagging-software.html
 

3 more replies
Relevance 44.69%

These release notes address critical late-breaking issues and information about this beta release of the Windows? 7 operating system. For less serious issues, refer to Things to Know About This Beta Release of Windows 7 (Download details: Release Documents for this Beta Release of Windows 7). Unless otherwise specified, these notes apply to all editions of Windows 7 that support the features mentioned in each note.
Accessibility

Microsoft? Narrator does not read information from the command line properly. This issue may also affect non-Microsoft screen reader applications.

To correct this, always run the command prompt with administrator privileges.

Apple iTunes

This issue only applies to 64-bit editions of Windows 7.

If you attempt to download and install Apple iTunes, the 32-bit version will be installed instead of the 64-bit version. This will prevent syncing with iPhone.

To avoid this, install the 64-bit version from the following location: iTunes 8.0.2 for Windows Vista 64-bit.

Backup
When you attempt to restore files backed up from a Windows 7 computer to a Windows Vista? computer using the Restore wizard on the Windows Vista computer, the restoration fails.

To work around this, in the location where the backup file is stored, locate the Mediaid.bin file, which is in inside a directory that has the same name as the computer. Move the Mediaid.bin file up one level, so that it is at the same level as the directory with the same name as the comp... Read more

Answer:Release Notes: Important Issues in This Beta Release of Windows 7

Thanks DA,

Excelent post

Everyone should read this info so have made thread sticky

9 more replies
Relevance 44.28%

Hello Members, just a quick question please
Will i be able to upgrade from Windows 8 Release Preview, to the Windows 8 final release, and when i mean the term upgrade, i'm talking any programs,files and settings i may have installed while using the Win 8 'Release Preview'.

I have searched this forum, aswell as other forums, i've also look at the Microsoft Windows 8 Release Preview 'frequently asked questions', but can't find clarity to this specific answer, does anyone know the answer please?

I havn't installed Win8 RP to my computer (Dell Inspiron 2320) a yet, so this issues what's holding me back.

Also what runs better, a Windows 7 to Windows 8 upgrade install (same drive partition)?, or, a dual boot with Windows 7 on it's original partition and Windows 8 on it own partition but still on the same hard drive, the reason i asked is that i gather in creating a new partition for Windows 8, the Windows 7 partition need to be compacted down, is there a performance impact to either OS?

Any info, or opinions would be great.

regards
Livio

Answer:Will i be able to upgrade Windows 8 Release Prev to the final release

Welcome to the EightForums! liviococcia

Once the finished retail product is available when launched you would need to perform a clean install as with any previous version of Windows. The backup tools however may allow you to preserve and restore user files and settings without too much problem.

The final details in the "pudding" so to speak will be known once the RTM(Release To Manufacturers) is seen. Clean installs are always the preferred option over upgrading over a previous version which can often carry some problems along with the upgrade.

With the Windows Easy Transfer option with 7 once all programs were back on a clean install the restoration of the backup made with that option was found to restore the files and settings with 7. I expect the same should be seen with 8 as well.

1 more replies
Relevance 44.28%

My mouse's right click is not functioning properly. When I press down the right mouse button, nothing happens, but when I release the button it seems to perform right mouse down and right mouse up at the same time. I figured this out through Browser Mouse Event Test Page. I have tried switching to a different mouse, but it still has the same issue. Everything else about my mouse seems to be fine(left click, movement, ect.). This makes me unable to hold down the right mouse button, which is required in most games.
Thanks

More replies
Relevance 44.28%

Source: Windows 7 Release Date And Release Candidate News

The Windows 7 Release Candidate has been made available by Microsoft for Technet and MSDN subscribers. Users with a subscription can go to the Technet or MSDN portal and download the release candidate of the upcoming Microsoft operating system where it is available as a 32-bit and 64-bit download. The public availability of the release candidate is expected on May 5 when users from all over the world will have the opportunity to download and test the Windows 7 Release Candidate.
The following links point directly to the release candidates at both the MSDN and Technet websites.

Technet 32-bit
Technet 64-bit
MSDN 32-bit
MSDN 64-bit

Probably even more important than the availability of the release candidate is the confirmation that Windows 7 will be released in the Holiday season by Microsoft Senior Vice President Bill Veghte. The release date was one of the best kept secrets with rumors ranging from an early 2009 to a late 2010 release. This essentially means that Microsoft will release the next Windows operating system in about six months.

Answer:Windows 7 Release Date And Release Candidate News

Funny i have been calling for a Nov release for a while now.

4 more replies
Relevance 43.87%

Hello,
On my Windows 10 pro PC, I'm running (BDTS 2017 + Voodoo Shield Pro + Malwarebytes 3), and this combo is very smooth for me, but when I saw the results of MT tests here : AV Test - MalwareTips - Bitdefender Report - March 2017 and here : AV Test - MalwareTips - Kaspersky Report - March 2017, I think that these tests demonstrated that Kaspersky did a better job then Bitdefender
So my question is to know if it is a good idea to replace BD by KIS on my config ?
Thanks
NB: I have paid keys for both
 

Answer:Bitdefender Total Security 2017 vs Kaspersky Internet Security 2017

1/ kaspersky with tweaked settings alone

2/ kaspersky, slightly tweaked + Voodoshield

3/ bitdedender with ATC = aggressive + ransomware protection enabled | Heuristics = normal
 

40 more replies
Relevance 43.46%

New Pre-Release Build: 21.0.0.100 is Now Available!
You can see more information here!

Final version is expected on 14th of September!
 

Answer:New pre-release build is available and information about release date

Is Norton End-Point for the Home User? And does it offer better protection?
Also, how is the Ram Usage? Just wondering?
 

5 more replies
Relevance 41.82%

Good evening everyone! Thank you for your access to here and reading my post.
Tonight, I want to ask you that how much the Avast Free Antivirus reaches some solid anti-malware software, which are the paid version.

Now I am using F-secure SAFE as Trial license on desktop PC, which is one of the mine.
It seems to nice for protect PC and F-secure SAFE is light despite it is one of the very strong scanning system as consumers.

But now, I am worrying about false blocking by browsing protection of F-secure SAFE.
In usually, f-secure is not making something to bad situation for me, I am feeling it.
But the Browsing protection feature of F-secure SAFE blocks websites too many times.
The most of sites,which were blocked by F-secure are obviously safe. Of cause, they are judged safe sites by other major antimalware soft (e.g. Avast, Bitdefender Total Security).

So I want to compare them; Avast Free Antivirus 2017 and F-secure SAFE 2017(or Internet Security 2017).
I want to ask you that which is the more strong software under the below situation...

1.
OS is Windows10 Home and updated with latest security patch.
2.
Main browser is the latest of Mozilla Firefox with ublock origin.
3.
If I use Avast Free 2017, I will configure some setting (e.g. File Shield, Mail Shield, Web Shield, and Behavior Shield) to aggressive security level. For example, I will configure by referring to this page avast! Optimal Protection settings by RejZoR​
I heard that the latest edition of Avast Free A... Read more

Answer:"Avast Free 2017 with aggressive setting" vs "F-secure SAFE 2017"

Try Avast with these settings. How to setup Avast Internet Security for Maximum Protection (2016 Guide)
 

1 more replies
Relevance 41.82%

the tablet will not release from the key board the screen that says the tablet is ready for removal never comes up

More replies
Relevance 41.82%

I know 2017 version of avg devoloped from Avast. And also both of them use the same engine. But i want to ask you a question. Which one have more feature at the moment? And which one do you recommend to install my computer?

Sorry for my bad english.

Thank you in advance.

Best regards.​
 

Answer:Avast 2017 vs AVG 2017

Hey man. Of the two I would choose Avast, much more reliable and customizable.
My personal choice is Bitdefender though. I believe you could do some research on Youtube so that you form your own opinion. Here are some interesting channels:

The PC Security Channel [TPSC]
Malware Blocker
cruelsister1
Aca Faca

Make sure to post on Security Configuration Wizard forum your full setup after you made your choice
 

26 more replies
Relevance 41.41%

Master Dates are in Column A. I want to "Match Dates to the Master Date Column" and at the same time move columns G,H,I with Column B. This would be data from 1988 too 2010 Daily data. End result, ( Transpose) Each year would start in Column J2:M2 the next year would be in J3:M2 and so on so forth.I'm working Excel 2007. Thank Youedited by moderator: email address deleted

Answer:Match and Move Dates to match Master Dates

I have edited your post to remove the email address. You should never post your email address in a public forum.Please do us a favor. Make believe that you are one of us - someone who can not see your spreadsheet nor know what you are trying to do. Then go back and reread your post. Does it make sense to you?re: Match Dates to the Master Date ColumnMatch from where?re: move columns G,H,I with Column BMove to where?re: End result, ( Transpose) Each year would start in Column J2:M2If you're moving 4 columns to 4 other columns, what is being Transposed?You need to give us some more information related to the current lay out of your sheet as well as the desired result before we can help you.Actual examples of "before" and "after" data is always useful.DerbyDad03Excel Forum Moderator

3 more replies
Relevance 38.13%

Just threw this article together, I want all the brain's in this forum to chip in and if there is anything missing from this article (at all!) let me know ASAP, in this thread.

A top quote :
Quote:




Previously we wrote a long post about Best Laptops for Hackers, which included a run-down on the best laptops for programming and penetration testing (pen-testing). This article turned out to be very popular even though it wasn't exactly intended to be that, now we are proud to finally publish the long-requested article of 'Best Laptops for Video Game System Emulation'.

The idea of this post is to give an accurate summary of which laptops are suited for, or adept at emulating various consoles and their games, and which ones also can easily perform these duties, at the lowest possible cost.

Now obviously, the better hardware you have the better your system will be at emulating other hardware/software. That doesn't necessarily mean a more expensive laptop. Where the demands of hacking and pen-testing demand vital and significant internal storage, the prerequisites for game emulation are generally just a good graphics processor, and good RAM/CPU.

Your laptop should also be in good working order and not muddled with high-risk pirated downloads and large bits of video. To emulate efficiently, you should also have as little processes and programs running in order for the emulator to run smoothly.

These are all common sense tips but...
If you are lo... Read more

More replies
Relevance 37.72%

Greetings,

I currently have Windows 8 Release Preview, it is my main OS. I have many programs,files,settings,etc.

My question is when the final version of Windows 8 comes out will I be able to upgrade to that version from my current version (Windows 8 Release Preview). What I mean by upgrade is not doing a clean install and having everything put into the windows.old folder.

Thank You.

Answer:Windows 8 Release Preview -> Windows 8 Final Release.

some minor hints that it won't work, nothing concrete though sorry.

4 more replies
Relevance 34.03%
Question: up dates

i have a gateway 4200-e series with windows xp-sp2. i
keep getting updates downloaded but it will not install them.i think there are 83 now. i have it set to automatically download but it will not install. ive tried to install from website and that doesnt work either. im not very tech savvy but will try what is suggested. anyone have a suggestion?

Answer:up dates

what happen if you try to install?any error message?

4 more replies
Relevance 34.03%
Question: Due Dates

Good morning
I am trying to create a spreadsheet that will run off of an existing Matrix I have. I would like it to tell me when and what is due with in 30 days and who needs to do it.
ie: the matrix basically had 5 tabs
in the spreadsheet it say

Name department Title of project & due
John Doe Paint 10/28/2009

How do I create another tab that will automatically tell me that John Doe must finish project A but 10/2009
 

More replies
Relevance 34.03%
Question: DATES

Hi, can someone help me with a date formula. I am looking to have a date automatically fill in for 6 weeks later.

so if date in is march 27th 2017 can I get it so date out is May 6th and etc for other dates.

thank you,

Donna
 

Answer:DATES

he yes
if the date is in cell A2 and you want B2 to be 6 weeks later - OR 42 days later

=date(year(a2),month(a2),day(a2)+42)
should add 42 days to the cell in A2 and show the result in B2

OR just use

A2+42 would do the same

I showed the date() formula as its useful to add months and years to a date
so if you wanted 3 months - that would work and take into account the different days in the month

Excel dates are just a number - serial number of the number of days since 0 jan 1900

so 1st jan 1900 is
1

and today 27th Mar 2017 is
42821

so if you add 42 to 42821
=
42863

excel will show
8th May 2017
 

1 more replies
Relevance 34.03%
Question: different dates

When I view my pics on a floppy disk, I get two different dates. Under the heading "In folder" I get something like A:\04-29-2001. Under the heading "Date Modified" I get a date and time, but it is always different from the other. What are the meanings of the two dates?
 

Answer:different dates

depends on the headings but you will have date created - date the files was created date modified when anything changed in file and date accessed

what are the date headings you have?

if you goto windows explorer

then view > choose details
 

1 more replies
Relevance 34.03%
Question: Up dates

My computer is stuck on up dates. For 3 days it has been saying about 18% It has all of the updates as far as I know. It will not let me click on it for the status. And I can't seem to stop it. If I restart, it will come back and start again. What can I do?

Answer:Up dates

Well...you could, as a start, disable automatic updates.

Then...you can either just manually go to the Windows Update Site and attempt to install updates...or download specific updates to your hard drive and then install them from there.

Louis

3 more replies
Relevance 34.03%
Question: php dates

i what to figure out the date that is excatly 30 before the current in php. I can get the current date but i don't know how to subtract 30 days from it. Any suggestions?

Thanks.

Peter
 

Answer:php dates

PHP:

<?php
$lastday 
mktime(000date('m'),date('d')-30,date('Y'));
echo 
strftime("The date 30 days ago was: %m/%d/%Y"$lastday);
?> 


That takes 30 days off the date and giv... Read more

4 more replies
Relevance 34.03%
Question: between dates

I have an access database and I would like to search for all records that fall in between to specified dates. I think I can do this in a query but Im not sure or the formulas. CAn anyone help me.
 

Answer:between dates

11 more replies
Relevance 34.03%
Question: using dates in XL

using vista home premium 64bit with office xp, I remember a thread here where one can set 2 dates, ie 4th march 08 and 20 july 09 and find out how many weeks/months/days between them, have done a search but cannot find info, can anybody point me in the right direction please, thanks

Answer:using dates in XL

With earlier date in A1=DATEDIF(A1,B1,"y")&" y "&DATEDIF(A1,B1,"ym")&" m "&DATEDIF(A1,B1,"md")&" d"

2 more replies
Relevance 34.03%
Question: SQL dates

I'm new to SQL.
I'd like to run a program in SQL once a week. I only want records updated since the last run. There is a field called processdate. I only want where processdate> today-7. How do I code that in SQL
 

Answer:SQL dates

6 more replies
Relevance 34.03%
Question: Sql Dates

I need an SQL SELECT INSERT statement which will return the dates of, for example, all wednesdays and thursdays betweens two dates, and then insert the dates, along with other data (from an SQL table) associated with those weekdays (wednesdays and thursdays) into another table. Is this even possible, and if so, how?
 

Answer:Sql Dates

8 more replies
Relevance 34.03%
Question: dates

Hi,
 

More replies
Relevance 34.03%

Windows 98 2nd E

The BIOS date is right! The issue is that ALL files existing on my computer are now dated 06/01/80 (all windows files everything!!). Any file created since the power supply was replaced has the correct date.

Is there any way to change the existing files' dates.

Power source died, has been replaced. We had problems as it was dying with the dates, now all dates are 06/01/80 I need to reset them in order to be able to put windows back in to fix other small problems.

ALL SUGGESTIONS WELCOME!!
 

Answer:All dates are 06/01/80-help!!

8 more replies
Relevance 34.03%
Question: Dates

Excel 2010
need a formula for getting the first Monday date of each month for 2016.
eg: 1/4/2016 + ????? will provide 2/1/2016
Thank you for your help
 

More replies
Relevance 34.03%
Question: UP dates

Can any one tell me why my notebook updates every time I shut down.
When I check resent updates It doesn't show any resent updates.
Claire

More replies
Relevance 33.62%

Does not everyone, as a matter of course, automatically check for (AV+WhotNot) up-dates when first using their computer for the day before doing anything else?I guess most must, so why post AVG, SpyBot, AdaWare, etc latest up-dates?

Answer:AV & Trojan Up-Dates?

as you said most which implies not all hence the updated postings.johnny.

8 more replies
Relevance 33.62%
Question: Automatic up-dates

Hi everyone, I need to switch my MS updates off.Could someone remind me how. thank you.

Answer:Automatic up-dates

If you are running XP go to START > SETTINGS > CONTROL PANEL > SYSTEM > AUTOMATIC UPDATES. CW

10 more replies
Relevance 33.62%
Question: excel dates

Filename: SysInfo.exe
Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe

____________________________

____________________________
Developers
Not Available

Version
1.0.0.2

Identified
6/27/2016 at 5:17:31 PM

Last Used
Not Available

Startup Item
No
____________________________
Many Users
Thousands of users in the Norton Community have used this file.

Mature
This file was released 4 years 8 months ago.

Good
Norton has given this file a good rating.
____________________________
Source File:
sysinfo.exe

____________________________
File Thumbprint - SHA:
8243b4ea661b060fe8cf4babc11ab5f51eadd28a0c9d66303183e8eceace8234
File Thumbprint - MD5:
Not available
 

Answer:excel dates

What is your problem and/or question?
 

2 more replies
Relevance 33.62%

Hello!I have a set of colums with the dates of every step of a given process (the date that each step was accomplished). But for some of the processes there is one step that is not necessary so the cell is either blank, or has N.A. and so the process will automatically go on to the next activity.Now, I want to study how long each step took to accomplish and I've been using the work days function to see how many days if took. But I was wondering if its possible to build an IF function that would calculate work days depending on whether there is a date on the previous activity or not. If there is a date then it would calculate normally, if not it would calculate the work days it took between the activity prior to that and this one.Any help?Thanks,

Answer:IF Function w/ dates

Not sure I understand what your looking for.If you have three Dates something like:
A B C
1) 10/01/2013 10/10/2013 10/21/2013
2) 10/01/2013 10/21/2013

Then in D1 a formula like: =IF(B1<>"",B1-A1,C1-A1)will test to first determine if B1 is Blank,If B1 is Not Blank then use the Date in B1If B1 is Blank then use the Date in C1 Is that what your looking to do?MIKEhttp://www.skeptic.com/message edited by mmcconaghy

5 more replies
Relevance 33.62%

help!I have a range of data that i need to analyze.if a date is 3/1/2014, then i need it to return +15 days later in the next columnand i have many dates that i need to do this do... can you help?

Answer:if statement using dates

Something like this might work:=IF(AND(MONTH(A1)=3,DAY(A1)=1,YEAR(A1)=2014), A1+15,"")Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

3 more replies
Relevance 33.62%
Question: Wordpro dates

How can I retain the date on my wordpro document so thtach time I open it does not change to the current date.

Answer:Wordpro dates

"Insert date as text" instead of "insert date as field."

1 more replies
Relevance 33.62%
Question: Excel Dates

Eldest daughter driving me mad.At business she is working on a database in Excel.She tries to shorten the DOB entry as for example23/11/29 for someone born in 1929 but it comes out as 23/11/2029 yet when she enters 23/11/31 it comes out as she wants it as 23/11/1931. Is there something we need to format in Cells/Date?Brambles

Answer:Excel Dates

and have the same problem! Using excell 2000 and my cells are formatted correctly. Very strange, however there are lots of very helpful people on this site and here's hoping.Taffy

3 more replies
Relevance 33.62%

EX:Launch date = 2/16/2014List for someone to select = T+1. T-0, T-1 etc...T+1 = 7 days after the launch, T-1 = 7 days before the launch etc...If want a formula that will take the list selection (T-1) and then count back by 7 days from the launch date to populate a due date for that action item.

Answer:IF statements with dates

When you say "List for someone to select = T+1. T-0, T-1 etc..." do you mean a Data Validation Drop Down List?If so, something like this might work.Column A contains the values for your Drop Down ListColumn B contains your launch dateColumn C contains the actual Drop DownColumn D contains the formula shownFor T-2, the formula will return 2/2/2014.
A B C D
1 T-2 2/16/2014 T-2 =RIGHT(C1,LEN(C1)-1)*7+B1
2 T-1
3 T+0
4 T+1
5 T+2
Note, if the "T" values will always be a single digit, then you can use this:=RIGHT(C1,2)*7+B1Using the LEN function as above allows for any value, such as 20, 137, etc., as long as the value doesn't result in an invalid date.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 33.62%
Question: Dates on Outlook

The dates on Outlook messages in my inbox have changed. Emails that were received weeks ago now show future dates i.e. 4/4/2006. New emails that I send show todays date as they should. I've checked the date/time clock in the right hand corner and it is correct. Anyone ever have this happen or know how I can correct it?
 

More replies
Relevance 33.62%

Hi for those that dont get their downloads automatically there are 4 to-night.

Answer:New Microsoft Up-dates

just installed them now. Cheers.

6 more replies
Relevance 33.62%

Hi all, thanks so much in advance!

I'm researching hotel rates over the course of several days and am trying to sort out a way to essentially update a collection of links on specific hotels (via Orbitz, Kayak, etc) to reflect daily date changes.

For example, here's a URL for a specific hotel on Kayak for a 1-night stay today:
"http://www.kayak.com/hotels#BEST-WESTERN-PLUS-Grosvenor-Airport-Hotel,San-Francisco,CA-c13852-h33965/2011-10-17/2011-10-18/2guests"

So tomorrow I want to come to this sheet, either update a master date field or otherwise increment those date values by 1.
I could probably get away with some code that applies today's date straight away but the other 1/2 of this task is to have another batch (just in a 2nd Sheet?) of links pointing to tomorrow's date (hence why a single solution that can be applied to both Sheets might me best vs 2 different solutions).

This may look like a simple Find/Replace function but I think it might be more complicated because I am also trying to manipulate URLs from 3 other travel sites that all embed the date in their URLs differently (ie, "10/17/2011...10/18/2011", "checkin_monthday=17&checkin_year_month=2011-10&checkout_monthday=18&checkout_year_month=2011-10", & "hotel.chkin=10%2F17%2F11&hotel.chkout=10%2F18%2F11")
Add to it some numeric strings in these URLs that might coincidentally match the 2 digit date values and throw off a regular find/re... Read more

Answer:Is this possible - Change dates in URL?

8 more replies
Relevance 33.62%

Is there a way to have excel recognize month change using an if statement?I am setting up monthly charts that need to vary based on the month, these charts are for a running calendar that requires calculations of three month intervals and overall totals, but they need to look pretty.Currently I have my main page set up where they can enter the month started and have been able to get the subsequent pages to change to the proper month. I can get the dates to populate but when it comes to months that have <31 days it is showing the date for the next month.Just for an understanding; these sheets can be started any month of the year. The quarterly results must be reported from start month to date.

Answer:Using IF statement and dates.

Well thanks to any who read this! I was able to figure it out after I posted this but thought that others may have this issue, so here is the results.=IF(AL36="","",(IF((AL36+1)=(EDATE($G$4,1)),"",AL36+1)))The outside if statement is to cover February, if this is not done it will work on the 29th cell if it is not a leap year but result in an error on the 30th cell.Where AL36 is the day before, G4 is the current month.So if AL36 is the 28th of Feb, 2012, then AL36+1 would be 29-Feb-12 and it would report it out, but if AL36 is the 28th of Feb, 2011 it would be blank.

2 more replies
Relevance 33.62%
Question: access dates.

Is there a specific way i need to enter dates in Access so that i can sort by the date?

I tried several formats but they all seem to return an illogical sequence>

Thanks
 

Answer:access dates.

16 more replies
Relevance 33.62%
Question: birth dates

Don't know if you can help me!Does anyone know if it is possible to find the DAY on which someone was born, by quoting the DATE of their birth.I seem to recall reading something on these lines in PC Advisor, but cannot find anything now.

Answer:birth dates

This link will do it for you click here and another one click hereand more mathematically - one algorithm for doing so, with some links.

3 more replies
Relevance 33.62%

Hi all. I'm wondering how to copy the Microsoft updates and hot fixes for XP from add & remove to cd. If you can burn the Microsoft updates and hot fixes for XP to cd, can you install them on your computer if you have crashed your computer and have to format and start again. Hope someone can answer this question.

Answer:how to copy xp up dates

greetings

you shouldnt need the hot fixes to get windows installed with internet function.

your not looking for a work-around for the validation tool , are you?

you can slipstream sp2 with your existing xp disk on to a burned disk, of course, you will need acccess to another computer with a cd burner and internet access.

http://www.maximumpc.com/2005/01/how_to_slipstre.html

2 more replies
Relevance 33.62%
Question: java up-dates

I have just logged onto the computer and there is a message that tells me that i have java updates is it safe for me to download these and what are they? Sorry to be a pain but i'm not to sure as to all of these things.

More replies
Relevance 33.62%
Question: Access Dates

I have tried to find the solution to this on the Internet but cannot find anything to help. I have a date field showing on a form. When a users enters a date I want another field to automatically display the day, i.e Mon, Tues etc. Is this possible?
 

Answer:Access Dates

Use the AfterUpdate exent for the first text box to read something like this

Me.SecondTextboxName = Format(DatePart("d", Me.FirstTextBoxName), "dddd")
 

1 more replies
Relevance 33.62%

Hello. I have put a macro in that works great for stripping/parsing numbers (for invoice numbers) out of any string, from that I need something like this:

I have two tabs with data. One is for invoices, one is for write offs. Basically assuming the date is in a certain week period that matches on both the invoice date and write off date tab (ie. between 5/16/2010 to 5/22/2010) then it will add the invoice $, if the invoice number was from an old date or a newer date then it will be ignored. I know this can be done with a SUMIF but I am having trouble with the dates also. Let me know if someone can help. So for example if the invoice tab has $300 issued on 5/16/2010 and written off on 5/16/2010 the formula it will add up $300, if the invoice was issued 1/10/2010 and written off 5/16/2010 it will not add up anything, because it must be in the 5/16/2010 to 5/22/2010 period. I will need to manually change this for previous weeks also, but I can manually do that myself, I just need the initial formula to start.

Thank you!!!!

If I could input the date between each week that would be fine, I could edit each formula for every period... or is a macro easier to do this?

X corresponds to some invoice$ amount, to not give too much "personal" data.

This is what I have so far (this could be incorrect, but it does add up the numbers, just without the dates I want): =IF(Date of Invoice is in the same week as the date of the write off then SUMIF(Inv!$G:$G,F596,Inv!$E:$E))

F596... Read more

Answer:SUMIF between dates

7 more replies
Relevance 33.62%

I am building an Access database (1st time user) and am having a hard time trying to figure out how to calculate date ranges. For instance, one thing I need is for the database to count 10 Business days. I guess one workaround would be to count 14 days. However, I also need to add in holidays. Can someone help me with this please.

Thanks,

Sandy
 

Answer:Calculating dates M-F

Greetings Sandy.

I use this: fNetWorkdays and fAddWorkDays

Works great and easy to use.
 

1 more replies
Relevance 33.62%

Basically im creating a spread sheet for my bills to keep track if they are paid late ect..How do I write an If/Then statement in excel to change data to say late or current depending on the date? I have one field for the current date, a1, and a column of due dates, d4-d48 I want to know if the due dates are past todays current date to populate to say late or current in column I.any ideas ?

Answer:if statement for dates?

Enter this in I4 and drag it down:=IF(D4<$A$1,"Late","Current")Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies