Use Excel to find the diff between dates

[jeroen1]

Hi,

I'm totally new to VB, so forgive me for any "stupid" questions. First I would like to know where I could find a good tutorial? but until I found one I would like to know the following:

Is it possible to create a script that reads 2 cells from a row containing two dates and have the script calculate the difference between these two dates?

thanks for any help.

regards,

jeroen

 

[johnwm]

Hi and welcome to Tek-Tips. Please read faq222-2244 to get the best from these forums.

For this question (which appears to be a VBA question, rather than a VB6 question) you should be posting in the VBA forum, forum707

And yes, it's very easy with a VB calc, or you could just format the cell as number, without any code!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[ZmrAbdulla]

Plese have alook at this link.

http://www.cpearson.com/excel/datedif.htm

for future on VBA post your question on Forum707 as johnwm pointed.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[SkipVought]

Also check out

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}