How to Calculate Days Between Dates in Excel

How to Calculate Days Between Dates in Excel

1. • Open a new workbook in Microsoft Excel. Type the start date in a cell. For example, type 12/22/1982 in cell A1.
   • Type the end date in another blank cell. As an example, type 6/8/2009 as the end date in cell A2.
   • Click on a blank cell and type "=DAYS360(start_date, end_date, method)". In the example above, the formula would be =DAYS360(A1,A2), which returns 9526 days. The formula assumes 360 days in a year (12 months with 30 days). The method argument specifies the calculation method. It can be left blank when working with U.S. dates, but must be set to TRUE when working with European dates.

Read More

Cannot run computer management on Mircosoft OS.

Try entering compmgmt.msc in Start / Search box and enter.  Double click on the program icon that appears and see if it opens.  I doubt this will work if clicking on the executable file didn't work, but it's worth a try.

Let's check some of your system files:

Go to Start / All Programs / Accessories / Command Prompt and right click on command prompt and click run as Administrator.

Type sfc /scannow and enter and let it run. 
It will scan and try to fix some system files.  Hopefully it will complete without any errors it couldn't repair (if such errors occur, post back here).

While you're in command prompt type chkdsk /f /r and enter and let it run.  It will look for and fix/mark bad sectors (and one of the computer management files may be in a bad sector which can be moved unless it's hopelessly corrupted).

Are you certain the problem is limited to Computer Management/  Have you tried to enter EventViewer or Services or anyghing else in Administrative Tools?  Please try.

Do you have a genuine Windows Vista Installation Disk (or can you borrow one from ANYONE).  If none of these efforts work, our next logical step would be a system repair/upgrade and we need the disk to do that.  They aren't copy-protected so you can use anyone's copy with your own product key which governs the version installed.

Let's see where this gets us.  Good luck and I hope this helps.  If it doesn't really try hard to get your hands on a disk.

Read More

great apps to handle emergency recoveries for your Computer

Great apps to handle emergency recoveries on your computer

   

Roadkil's Unstoppable Copier

       
    Roadkil's Unstoppable Copier does one thing and it does it well: It copies data from broken drives. And it's good at it. But UC isn't just for getting data off broken drives. You can also use it as a daily backup (using the Batch Mode function).
   

BlueScreenView

             There is one catch here. I am a fan of the CCleaner tool. By default, CCleaner is set up to remove all those memory dump files. So if you use CCleaner, be sure you uncheck the option to delete those files. Otherwise, a tool like BlueScreenView will be of no use        

BlueScreenView

       
    When Windows blue screens, it spits out a core dump that contains a lot of valuable  information. BlueScreenView scans the dump files and displays information about the BSOD crashes in table format, making troubleshooting much easier.
   
       

PuTTY

       
    Being able to secure shell into a remote machine at all times is invaluable. The use of the simple RDP protocol is fine for some, but it's not nearly as secure as it should be. If you want your remote logins to be secure, add a little ssh goodness to your toolkit. PuTTY gives you just that.
   
KNOPPIX
       
    KNOPPIX is a live Linux distribution that can fit on a flash drive. With it, you can boot into a full-blown Linux distribution that contains many helpful tools.
   
       

ComboFix

       
    ComboFix is the Mac Daddy of virus and malware removal tool. After a successful run of ComboFix, you should have cleaned (if applicable) malware, rootkits, Trojans, worms, and viruses.

Read More

How to boot Windows 7 from a USB Flash Drive Step By Step

Step by Step on how to install Windows 7 from a USB Flash Drive.

Download Diskpart form Microsoft site

Run diskpart

Type : List disk

You should see your Flash drive

Type: select disk 1

Type clean

Type create partition primary

Type active

Type format fs=fat32 quick

Type assign  (so a drive letter is assign to the flash drive)

Copy the whole files from dvd to the flash drive.

Your done and have a bootable windows 7 flash drive

Read More

Error -6123, 0: Connection to the QuickBooks

Error -6123, 0: Connection to the QuickBooks company file has been lost

When opening or while using a QuickBooks company file over a network, you see one or more of the following errors: -6123,0 connection to the quickbooks company file has been lost.

Step By Step:
First boot both computer or the computer that use Quickbooks. 
Bring up the file on the host computer.
Click on File Utilities
Make user your are hosting in mutli user

Now open the Quickbooks on Computer 2
Before you open the Company file
Click on File
Click on Utilities
Click on STOP Hosting Multi User.

Now Click on File
Open Company File
on the bottom right  make sure to check Open File in Multi-user mode.

This will solve the connection on quickbooks with this error -6123, 0

any question call Elitebuyer.com at 562-366-4177
Computer Support and Service

Read More

How to Uninstall any program from Windows

Perfect uninstaller V6.3.2 is an easier and better way to uninstall any unrequired application that standard windows add/remove program cannot remove.

USES OF PERFECT UNINSTALLER

With perfect uninstaller you remove unneeded applications and clean the registry files. This software helps in improving the speed and performance of your pc and protects it against corrupted files as well.
Download tutorial as pdf: Perfect Uninstaller Review
Now let us check out the step by step processs to download and use perfect uninstaller.

A. Go to www.perfectuninstall.com

B. Click on “Free Demo Download”.

C. Click ‘Run’ on the window that opens to start installation of the software.

D. Choose an easily approachable destination to save the executable file and click ‘Save’.

E. Wait while the download completes.

F. Now when the download is complete, open the folder where you saved the executable file. Next Right-Click on it and then click on ‘Open’ to start the installation.

G. Now a welcome screen would appear. Click on the ‘Next’ button.

H. Accept the license agreement by marking the ‘I accept the agreement’ radio button and then click on ‘Next’.

I. Next, select the destination folder for Perfect Uninstaler to be installed into and then click on ‘Next’.

J. You may select a few additional tasks such as creating a quick launch icon or a desktop icon and the click ‘Next’.

K. Click on ‘Install’ to proceed with the installation.

L. Click on ‘Finish’ to complete the installation process.

****** PERFECT UNINSTALLER ******

Perfect unistaller is 3 times faster than your pc add/remove program and it forcibly removes hidden applications in your system. It has a user-friendly interface and is very easy to use. There are three ways to view the application: by list, by icons and by details.

***** HOW PERFECT UNINSTALLER WORKS *****

Select the application you want to uninstall from the list of applications and click on “uninstall” button.
There are 3 ways to uninstall:
1) Uninstall (Normal)
2) Force Uninstall (Used when normal uninstall is not possible)
3) Special Uninstall (Used in rare cases)

Click on “Next” button in the screen that appears.

After you click on “uninstall” button, this screen would appear. Click on “next” button on this screen.

Again click on ‘Next’ button to continue with the uninstallation.

After clicking on “next” button, the following screen appears which shows the 3 stages of uninstallation process of the selected application. Again click on “next” button to continue.

Click on “OK” to confirm uninstallation of the selected application.

Next a screen appears confirming your uninstallation process. Click on “OK” to uninstall the selected application.

Wait until files are being deleted by perfect uninstaller and the uninstallation process is complete.

Click on “OK” to complete the uninstalltion process. This shows that the selected application has been deleted from your system.

After completing step 1 of uninstallation process, this screen shows that the perfect uninstaller now scans for the left over registry files.

Next, it completes the last step of the uninstallation process which is to scan the drivers for left over files.

The wizard makes you go through the entire uninstallation process. After this, click on “next” button to continue.

When the “How to delete screen” appears, then click on “Yes” to delete the selected application forever.

Lastly, click on “Finish” to complete the uninstallation process.

SYSTEM MANAGER

Additionally, Perfect Uninstaller offers the option of registry backup in case your system becomes slow or crashes.

Click on ‘Restore’ to recover the requisite important files.

You can also recover essential files using the restore option.

Click on ‘Startup Manager’ and view the entire list of enabled files.

You can also disable them by selecting the files to be deleted.

You have successfully learnt all about uninstallation through this software.

Read More

Never Miss An Important Mail from your Outlook with Important Mail Alert add-in

EliteBuyer.com

Never Miss An Important Mail from your Outlook with Important Mail Alert add-in

Emails labeled as Important are supposed to be meant important. But the thing is everyone can label it and the definition of importance is different from one person to another. Sometimes, even the same person has the difficulty keeping up the same and label things are differently depending on the day, mode, or even the food.
So the built-in Important emails in Outlook never worked well but here is a solution that might work out much better.
Instead of based on the label on individual emails, what about you put some your own rules to measure the importance automatically based on them?
Important Mail Alert is an Outlook add-in that marks and notifies you when an important email arrived based on the rules you have set up.
Once you installed this add-in, you need to re-open your Outlook to have it loaded properly. You will see a gray bar/box down at the bottom of your Inbox message panel, once it’s loaded. It turns to a bright yellow when it detects an important message arrived.

You will also get a popup notifying you the same, to get more your attention.

Because it stands out so much that it hardly can get missed or lost.
The rules are a bunch of text you type in. If an email contains one of these texts it will be labeled as important. And then a yellow popup like above pops up while the alert windows turns to yellow the same time.
Important Mail Alert works seamlessly with Microsoft Exchange Server. It even supports the public folder as well.

Important Mail Alert is compatible with Outlook 2003 and above. It is the second Microsoft Office add-ins by AbleBits we covered here. The other one is a Note&Todo, which is also a fabulous add-in you might like. Both add-ins are completely free for both commercial and non-commercial use.

Read More