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 Saturday and Sunday comes between then the target date is the next working date.
Can anyone please help me to get this resolved?
Can anyone please help me to get this resolved?
17 Replies
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
