Excel formula query

  freddy-firecracker 16:58 08 Nov 04

I am trying to set a spreadsheet up which can calculate years & days between two dates, result can be displayed in two cells if needed. e.g years & days. What makes it harder is that this sum will be repeated several times in the worksheet and i need a sub total somewhere in the spreadsheet which calculates the total years & days for each individual cell.

e.g A1- 1/1/00 B1 1/1/01 C1 - 1 year 1 day
A2 -2/1/01 B1 1/12/01 C2 -1 year 1 day

Total years/days 2 years 2 days

any help appreciated



  VoG II 17:38 08 Nov 04

Download click here and look at the DATEDIF function. See click here as well.

  PA28 19:14 08 Nov 04

Neat link VoG™ - particularly the second one.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…