Convert Formula to Function | PercentBetweenDates
Experts, I'm trying to convert this formula:
=IFERROR((DATEDIF(A1,TODAY(),"d")+1)/(DATEDIF(A1,B1,"d")+1),"Not start") to a VBA Function. Do you know how this can be done and just write at excel =PercentBetweenDates(A1,B1)
Here is the function header that i want to use, please let me know if its feasible and any of you knows how to do it.
Please Login or Register to view this content.
Last edited by pacosalasv; 03-01-2022 at 10:07 AM.
Try this:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
It works so good if i run the macro with a button or call inside an other. But its possible to Type as formula inside cells? Such as we type for example = sum (Cell1,Cell2)?Originally Posted by TMS
I mean, i want to dynamically select the cells from formula. like =PercentBetweenDates(XXX,YYY) instead of pre-define insides the macro as A1, B1. (I'm not sure if its possible)
Please Login or Register to view this content.
Ben Van Johnson
I think it would need to be this:
Note: StartDate.Address and FinishDate.Address rather than just StartDate and FinishDate
Please Login or Register to view this content.
Works exactly how I expected. Thanks a lot for supportI think it would need to be this:
Note: StartDate.Address and FinishDate.Address rather than just StartDate and FinishDate
Please Login or Register to view this content.@TMS & @protonLeah
Happy coding!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks