DATE COMPUTATIONS

S

sonarmark

alright perhaps I am too much of a novice to understand

how do I do this?

1 2 3
a 1990 01 25 1993 07 21 =a2-a1 (displayed as "03 09 16")
b 1993 07 22 1999 04 29 =b2-b1 (displayed as "06 02 23")
c (sum a3+b3 displayed
as yyyy mm dd)


I have been working on this for a while and it seems impossible
 
F

Fred Smith

Format column 3 as general, or as a number, so it displays the way you want
it. There's nothing wrong with your computations.

Regards,
Fred.
 

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

Top