Hi,
I have a question, i have a start date a date paid till and also a number of weeks paid column, now inside the column Date Paid Till i have the following formula =Start Date+7*Number of Weeks Paid Column in my excel document.
Now what im having a issue with is when i put in an spent amount, the number of weeks paid column is going down as it should be but also the date paid till column as well but i don't want the Paid Till column to go down but it still needs to go up when i put in a win amount.
What do i need to add to the code to get this to work, any ideas.
Thanks
Donald
Bookmarks