Arun Singh:
Since the total period of contrat is 36 months and 30 months are already expired (6+12+12)(cell no k6+m6+o6)Q6 should restrict to 6 only
Arun Singh:
Since the total period of contrat is 36 months and 30 months are already expired (6+12+12)(cell no k6+m6+o6)Q6 should restrict to 6 only
Hello caarun1983 and Welcome to Excel Forum.
Note that this question should be in the Excel Formulas & Functions forum (please ask a moderator to move it).
In order to keep the formulas in columns K, M, O and Q consistent the formula in column K is modified to read: =IFERROR(DATEDIF(EOMONTH($F6,-1),MIN(EOMONTH($G6,0),DATE(2022,3,31)),"m"),0)
In column Q the formula is: =IFERROR(DATEDIF(EOMONTH($F6,-1),MIN(EOMONTH($G6,0),DATE(2025,3,31)),"m"),0)-($K6+$M6+$O6)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thanks a lot Jete for help
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
Thanks for the help
Can you help the same situtation with number of days instead of month
You have started a new thread for the days question, which is fine, but this thread needs marking as SOLVED.
All participants: no responses here to the days question, please.
Go here: https://www.excelforum.com/excel-new...nt-bucket.html
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks