View Single Post
  #5   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

Dear Claus,
Thank you!
Have you some suggestion to express the results in column C in days, hours, minutes, etc instead integrer numbers of months or years? In addition it would be nice to me express exactly such units in each column like C = years, D = months, E = days, F = hours.
For example using also fractional numbers like for days 365.25 or for years 1.23
Thanks in advance,
Luciano

Em quinta-feira, 18 de julho de 2013 12h10min42s UTC-3, Claus Busch escreveu:
Hi Luciano,



Am Thu, 18 Jul 2013 07:58:30 -0700 (PDT) schrieb Luciano:



Thank you for your post, but unfortunately for some reason your suggestion did not work here.




please look he

https://skydrive.live.com/#cid=9378A...121822A3%21326

for the workbook "Datedif"





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2