Calculate period between multiple dates _VBA script
Hi All,
Could you help me with excel VBA to calculate period between multiple dates. I have a big data , data has multiple dates are in there. I know how to calculate period between two dates but these are 3 and 4 dates on in it. Date format is MM/DD/YYYY format. If I get any VBA script that would be great. For example, Please refer attachment.
Many thanks in advance.Thanks for your help
Would it not be the most recent day minus to oldest date? The in-between days are irrelevant!
Or am I misunderstanding the context??
Regards,
Rudi
any help plsss
Try this code:
Select the empty cell below the date column and run the macro.
The macro calculates the difference between the FIRST date and the LAST date in the cells above the empty cell you select and displays the difference in days.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks