I want to get current date and check the current date falls under which Cut off period column in excel and based on cutoff period date I want to display subsequent “Pay period” value in variable or assign value to input for my application
e.g Current date = 21/02/2023 so it will falls under “16/02/2023 to 28/02/2023” cutoff period and payperiod for that cutoff period is 102304
i want display 102304 .
Can you please help me resolve this logic , I tried some logic not able to proceed further .Let me know if anyone has solutions for this already .