I have searched but can't see this specific question.
Basically the question is how to add moths to a date, i need to have a
column that has column F's dates + 10 months.  However, the column F dates
are all month end days, so 31/8/07 or 28/02/06 or 30/06/07.

If i want to switch between screens on my PC, i can use Alt and then Tab.  I
am looking for similar functionality so that i can switch easily between 2
worksheets on the same excel spreadsheet.  Any ideas?

Can any one suggest me to create a macro in VBA for removing merged cell,
autofit the data and center align the contents.
Thanks in advance.

How do I print different worksheet block selections on one page?

To all,
This is probably a very obvious question, but I cant get my head
around it. I have two cells containing the values 22:01:50 and
22:01:42. When I subtract 22:01:42 from 22:01:50, I get 00:00:08.

At work I'm running Excel 2002. I want to use the SUMIFS function but I
believe this function is only for Excel 2007. Is there a similar funtion in
2002?
I'm trying to sum a range using multiple criteria from within the same

To convert date From Western to Arabic Hjri

Can any one explain me what is sum product and how does it works...
And also the array....
Thanks in advance...

My data includes a column list of date/times.  I want to show only the time
if the date is the same as the one above, and show both date and time only
for new dates.  Is there any way to do it?  (I am using Excel 2000, but
upgrade to 2007 is pending.)

Can any one clarify how to remove merged cells, autofit the data and center
align the contents by having a formula.
Thanks in advance

Hi
Service Matrix - Days
Vancouver    7
Calgary        5

I thought I was being really clever and created an excel advent calendar
where every day a new sales incentive for my staff appears (for a bit of fun
at Christmas!)
But it was using today() and then an if sum refering to this date with a

I have a complaints database that measures trends. One of the trends we will
be looking at is how many complaints were opened per week. The dates each
complaint is opened uses this format 12-Nov-07.
I need to count all the complaints opened in a particular week using the

My spreadsheet has a list of dates and data in rows 9 through 500.
Dates are shown in Column A of these rows and data is in Column Q of
these rows.  There is also a summary section in row 6, and I would
like to enter a formula in row 6 that will show the latest entry in

Hi, i need a stock control system sheet, someone have one, please send me it.