Dear Sir,
AUTO EXCEL FORMULA NEEDED FOR NEXT DUE DATE OF MY AIR TICKET AFTER REMOVING MY LEAVE DAYS.
THANKS AND REGARDS,
DACKSON JOSE
Dear Sir,
AUTO EXCEL FORMULA NEEDED FOR NEXT DUE DATE OF MY AIR TICKET AFTER REMOVING MY LEAVE DAYS.
THANKS AND REGARDS,
DACKSON JOSE
What's an air ticket?
Seriously though... How many days a week do you work? Which days?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi sir,
out of b4:c10 balance all days worked.
Thanks
Not clear what the logic is - please explain in more detail, and don't type in ALL CAPS, as it is deemed as shouting. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Is the YEAR of your expected answer correct???
Hi Sir,
Yearly I have one holiday ticket approx (1000$), It is eligible for 365 worked days. Suppose in between this duration i will took 10 days leave then my next due date will be (duration 365+ leave days 10) = 375 days, means leave days exclusive for due.
But task is formula has to calculated all of my leave days means B4:C10 area.
Thanks.
Did I go invisible?
Yes. I understand the problem now. Whether intentionally or otherwise, your choice of leave dates was VERY clever. The easy formula dosn't work.
Mmmm.
OK. This involves a change in layout. If you REALLY want, I can try to automate the process of geting a coherent list of leave days.
=WORKDAY.INTL($C$12,365,"0000000",$K$2:$K$51)
Yes Sir,
This was very clever leave days sir, because it has to work any type of leave days will came, for example kindly change C4 date as 03/08/2019 then next due date correct answer will be 31/03/2020. The reason was, for example we add 2 more leave days and previous due date was 28-03-2020 + 2 days is 30-3-2020, But 30-3-2020 is next leave day B8:C8 then due date has to jump next day 31-3-2020.
Thanks.
Yup - completely invisible. Good job Glenn was able to help.
I do not follow this:
This was very clever leave days sir, because it has to work any type of leave days will came, for example kindly change C4 date as 03/08/2019 then next due date correct answer will be 31/03/2020. The reason was, for example we add 2 more leave days and previous due date was 28-03-2020 + 2 days is 30-3-2020, But 30-3-2020 is next leave day B8:C8 then due date has to jump next day 31-3-2020.
Please amend your sheet and SHOW me the problem.
hi sir
please find attachment.
In J2, copied down:
=IFERROR(INDEX($B$4:$B$10,MATCH(0,INDEX(--(COUNTIF($J$1:J1,$B$4:$B$10)=$D$4:$D$10),0),0)),"")
In K2, copied down:
=IFERROR(J2+COUNTIF(J$2:J2,J2)-1,"")
I created a Named Range (Leave) using this formula:
=Sheet1!$K$2:INDEX(Sheet1!$K:$K,MATCH(10^100,Sheet1!$K:$K))
this adjusts the range of cells selected for calculation of the result.
Then the formula in C18, is fully automatic:
=WORKDAY.INTL($C$12,365,"0000000",Leave)
The helpers can be hidden, or be on another sheet, if you wish.
I have just seen your attachment. Please check out your problem on my most recent iteration at Post 14. You deleted the working part of my solution, so of course it does not work!!!
Sorry sir,
This for one sample ok, unfortunately my data was this format. what do sir....
Please help me for a solution sir...
Thanks.
Whydid you now show us this from the start?
Not very helpful. I am away for 2 hours.
take your own time sir, i will wait for you sir...
thanks
Hi Sir,
Please look in to priority wise.
Thanks.
Administrative Note:
We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only a couple of hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
Just who do you think you are? I said I would be away for a while. Good luck and goodbye.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks