HI, This is my input in excel is the below TDVDRatesJoe 47107455030.05Mary47289455860.01Greg47289455890.01Matt47472456140.05 Desired Output - TDVDRates2028-12-202024-07-305002029-06-202024-10-211002029-06-202024-10-241002029-12-202024-11-18500

Date and Rate - Different format output

HI,

This is my input in excel is the below

Desired Output -

Workflow

Output

Date Time

Help

@EmilAlteryx01 This just requires a bit of Formulas - I encourage you to search how to convert Excel numbers into dates as there are many Community articles on this! Here is one example: Excel numeric to Alteryx date - Alteryx Community

Also a multiplier for the rate should be pretty straight forward, just multiply by 100

Also a multiplier for the rate should be pretty straight forward, just multiply by 100

Thanks Castor -- i did try and hunt for an example - this one you attached is perfect.. Issue resolved

Fantastic - go ahead and mark the response as a solution then!