how can subtact or add Week 07/2009 in one column & Week 10/2009 .

  • Thread starter Thread starter Pooja
  • Start date Start date
P

Pooja

pls let me about this quection...How can i add or subtract this from Week
07/2009 in one column & Week 10/2009 in another column.
 
Hi,

I'm not clear what you are trying to do. There are 7 days in a week so what
are you trying to add to what. If the date is 7/1/09 that gives a different
result that if it is 7/5/09 and both are in one week. Also by 7/2009 do you
mean the seventh week of 2009 or July 2009?



cheers,
Shane Devenshire
 
We need more details on how the data is stored. Generally, you would use a
Sumif or Sumproduct function to do the calculations.

Regards,
Fred.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count based on date criteria 1
Number of hrs worked in a week, based on dates in a different column 1
Update all tabs, incrementing one week per tab 1
How can i set a formula which shows 2nd last Monday of the month? 5
Count no. of occurance in 2 dynamic columns within a data period 7
help with datedif function please 4
Help required on week function 4
Excel 2007 4

Back
Top