Hi friends i have an excel where i have columns suchas due date, payment amount and week 1 , week 2 upto week 13. I need to write the payment amount to the matching week column based on due date. Always a week starts from monday and ends on sunday. If any date within that goes to week 1 itself. So i have tried few logics but am not able to get this corrwctly. Can anyone help me with this please?
You have a function get week of the year which would give the week number directly
Them that can use used in find/replace to find the respective row and write the data
Cheers
Thank you for responding. I have found another logic like finding the week start and weekend store it in Dictionary and then comparing @Anil_G 
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.