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