Subtract dates to give a total amount of days - Multiple Data

[t_man000]

Hi,

I need the number of days from the start date to finish data in another table. Please see attached data. I need it done for all parts. So for instance the first lot of data has 4 days between the dates under colomn HistoryDateTime. I have a lot more data, but is there a way to speed up the process instaed of working out each time individually?


Thanks
DarrenPallet History.xls

[cbatrody]

Hi,

Try the following formula in H2 and drag down:

=IF(F2="",ROUND(F1-VLOOKUP(A1,A:F,6,0),0),"")

[t_man000]

Hi Cbatrody,

You legend! Works a treat.

Cheers