Hi All!
I am trying to build a weekly cashflow. To do this I want to download my Aged Analysis from Quickbooks and create a formula that will analyse the aging into the relevant column. I envisage that this would be based on aging+normal payment days with an analysis of dates. I have tried loads but cant quite get there. I have tried a string of If(And) statements but cant get it to work.
I think I want look at the average days to pay, add it to todays date(which will be each Monday when I update my cashflow), and then put it into a column ran of dates.
I am attaching a sample of the data - if anyone can help Id really, really appreciate it! I have been trying this all yesterday afternoon and again this morning and have failed
Thanks
Molcon
PS I am a newbie and cannot see how to upload an attachment but my spreadsheet is just a list of customers with ageing (30, 31-60, etc), average days to pay figure and 15 weekly columns.
I want to get formula to look at the aging, look at the due date and calculate which week to put it into....
Am I asking too much ??
M x
I am trying to build a weekly cashflow. To do this I want to download my Aged Analysis from Quickbooks and create a formula that will analyse the aging into the relevant column. I envisage that this would be based on aging+normal payment days with an analysis of dates. I have tried loads but cant quite get there. I have tried a string of If(And) statements but cant get it to work.
I think I want look at the average days to pay, add it to todays date(which will be each Monday when I update my cashflow), and then put it into a column ran of dates.
I am attaching a sample of the data - if anyone can help Id really, really appreciate it! I have been trying this all yesterday afternoon and again this morning and have failed
Thanks
Molcon
PS I am a newbie and cannot see how to upload an attachment but my spreadsheet is just a list of customers with ageing (30, 31-60, etc), average days to pay figure and 15 weekly columns.
I want to get formula to look at the aging, look at the due date and calculate which week to put it into....
Am I asking too much ??
M x
