Scott Gottlieb, CPA

105 Maxess Road, Suite N116
Melville, New York 11747

Office: 631-574-4484 or 631-253-CPA2

631-574-4484 phone
American Institute of CPA'S
Member of BNI
Certified Quickbooks Pro Advisor
Registered In NY

certified quickbooks proadvisor
  For My Clients
  City/State/Federal Tax Forms & Revenue Links
  IRS Information For All
  NYC Business Forms
  State Business Forms
  Federal Business Forms
  Quickbook Updates
  Links of Interest
  U.S. Tax Code
  Tax & Government Links
  Tax Humor & History
  Contact Us
  Articles & News
  Current Article
  Archived Tax Articles
  American Recovery
Reinvestment Act 2009
  Archives Interest Sites

Balance Budget Act 1997


Never Underestimate the Value of A CPA

Pet Adoption










December 1999

Editor: Scott Gottlieb, CPA
Assistant editor: Susan A. Maffetone, CPA

Highlighting Excel Features

Make a Copy That Excludes Hidden Cells in Excel 2000

When outlining or subtotals to create a small summary of a large set of data, you can make a copy of just the displayed cells in the summary, excluding the detail.
First display only the summary rows or columns, and then select all of the summary data.
On the Edit menu, click Go To, click Special, and then click Visible cells only.
Now click the Copy button, click a cell on a blank worksheet, and click the Paste button.
The copy includes only the summary data.


Calculate the Amount of Time Between Two Dates in Excel 97/2000

You can simply subtract the two dates.
For example, if cell A1 contains the date 6/8/2000 and A2 contains 6/20/2000, the formula =A2-A1 calculates the number of days between these dates (12). Be sure to use number format for the cell where you enter this formula (click Cells on the Format menu, click the Number tab, and then click Number under Category).
If you don't format the cell with number format, Excel assumes the result has the same format as the cells used in the calculation, and displays the result as a date instead of a number.


And don’t forget to add this to your bookmark or favorites menu to help you in visiting us monthly. 

Other issues of NewsBytes see our archives





1997-2009 Scott Gottlieb, CPA. All Rights Reserved.

Disclaimer/Use of Site

The materials on this Web site are for informational purposes only and are not intended and should not be construed as accounting advice. This information is not intended to create, and receipt of it does not constitute, a CPA-Client relationship. You should not act upon this information without seeking counsel from a Certified Public Accountant