I want to automatically calculate a date when an invoice is due depending on the day of the week. For example:
the service is provided on a Monday so expenses for the job will be 18 days later and the labour will be on an invoice 25 days later. Tuesday would be 17 days and 24 days etc. invoice date is always a Friday .
If i have the delivery date in A2, the day of the week is B2, expenses date C2 and Labour date D2, what formula do I need to show the relevant dates
Can anyone assist me please
System Configuration: Windows / Chrome 72.0.3626.81
Thanks, however it's only to record when payments will be made. If I do the work on a Monday the expenses for the job will be paid 18 days later and the labour 25 days later, if it's carried out on a Tuesday it's 17 & 24 days respectively, wednesday it's 16 & 23, Thursday it's 15 & 22 and finally Friday 14 & 21. Hope that makes it clearer
I appreciate what you are saying however, your suggestion doesn't do what I want it to do which is why I gave the information in my second post. I know how to add days to a date. I want to be able to calculate it depending on the day of the week not just the date. I have tried using an IF and I can get it to work with just one day for example:
IF(D3="Monday", D2+18) returns the correct date (D2 is the date the work was completed)
when I nest the IF formula to add an extra date it does not change the end date, I presume I am missing something:
IF(D3="Monday", D2+18, IF D3="Tuesday",D2+17))
I have also tried using an OR but I think I am missing something there too
I have worked in my opinion an untidy way of getting the result I want which has a nested IF in a hidden cell to do the calculation for the day of the week and then adding the result to the date (D2). If there is a better way then I appreciate any advice
I'm curious to know why IF(D3="Monday", D2+18,IF(D3="Tuesday",D2+17)) doesn't produce the right result when IF(D3="Monday",D2+18) does. It should either change the date from D2 (by adding either 17 or 18) or show 'False' and not just show the date from D2.