VBA to compare between two dates (Days)

[dhiresh]

HI VBA Gurus,
I have a spreadsheet with data from A17 to AG1000. Column B is used for inserting appropriate dates and I want to calculate number of days using VBA in column AH and the code I have been playing with is:-

Please Login or Register  to view this content.

Please can you help.

Rgds

[Swindon Dominic]

Hi

Have you looked at the Help on the VBA function DateDiff? It includes an example for calculating the difference in days.

Regards

Dominic