Forum Discussion
How to get a target date for billing date that fall in particular date range?
I am working to get a target for a billing date that fall in a given date range. Like for example if sale is made on 1st April than it comes in date range 1-7 so the target date become 8th but if Satu...
Let's say the sale date is in D1. Does the following formula do what you want?
=WORKDAY(D1+6,1)
Thank you very much. This formula did worked for 3 date ranges but I have four date range 1-7, 8-15, 16-22, and the fourth one is 23 to End of the month. Can you help me for the 4th date range as well.
- For 23 - 30 April target date should be 5th of May
Could you attach a sample workbook with examples of sale dates and of the expected target dates?
- I have attached example of sales date and their target dates for feb and March months. Let me know if you need anything else.