View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Luciano[_2_] Luciano[_2_] is offline
external usenet poster
 
Posts: 30
Default Subtracting AD and/or BC dates

Hi Claus,
Yes, but I believe that it is a good approximation. Now I have a new "problem" to solve that is look for a specific sum of values in a column that match a specific criterium. For example: Look for the situations for which the value is 30 and type this value in an adjacent column:
5.0
18.0
12.0 30.0
11.0
6.0
1.0
11.0
24.0
11.0
6.0
6.0
12.0
6.0 30.0
5.0
12.0


Em sábado, 20 de julho de 2013 06h22min51s UTC-3, Claus Busch escreveu:
Hi Luciano,



Am Fri, 19 Jul 2013 07:17:52 -0700 (PDT) schrieb Luciano:



There was a cell format problem with my sheet.




you know that this calculation is not exactly because there have been

some calendar changes in your period?





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2