Using vlookup with days360

[needhelpduh]

Hi guys,

I have one worksheet with two tabs that are being utilized. One tab has all the data with 9 columns, and the other has one cell that I want to use. What I'm trying to do is calculate the number of days between two dates by referencing the other excel sheet/tab at the bottom.

I'm pretty sure I use vlookup to reference the account number, and possibly days360 to calculate the number of days between two different dates per that account? I want that one cell on one tab to show the calculated days between two different dates with the two different dates being on the other tab. I hope I'm being clear on that.

I'm new to excel, and only know the basics, so your help would be highly appreciated!

Thanks

 

[Prashod]

use your vlookup to lookup the dates and use these formulas from the link

http://office.microsoft.com/en-us/e...difference-between-two-dates-HP003056111.aspx