Summing dates

  • Thread starter Thread starter Snergle
  • Start date Start date
S

Snergle

I have table like this
Date 1 Date2 Diff Date2-Date1
19.12.05 10.01.06 0Y 0M 22D

14.01.05 26.02.05 0Y 1M 13D



Which formula to use to sum dates in column 3.
For easyer calculations assume that month have 30 days.

Tahnx
 
Just subtract

=B2-A2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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

Summing dates 1
Access Dcount (multiple criteria) 3
Datediff Help 3
No.f days between dates, no w/e and Fridays 2
Calculating Age In VBA (Chip Pearson) 3
sumproduct ? 4
how to return an address from a lookup into a table? 7
Formula for # weeks between 2 dates 3

Back
Top