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...
Try this:
=WORKDAY(WORKDAY(DATE(YEAR(A2),MONTH(A2),IFS(DAY(A2)<=7,7,DAY(A2)<=15,15,DAY(A2)<=22,22,DAY(A2)>22,DAY(EOMONTH(A2,0))))+3,1),1)
It's not working giving #Name? Error.
Ah yes, the IFS function was not in Excel 2010.
- Thank you very much for helping me.
I was getting error as I was using excel 2010 version but then I changed formula slightly and used choose function instead of ifs and than it started working.