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...
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.
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.
Ah yes, the IFS function was not in Excel 2010.