LinkBack URL
About LinkBacks
How to arrange two date difference in Datewise / Monthwise format in Different Cells And return periodic date matching data
I am attaching Excel Workbook for reference and Comments so You can understand my point of view properly.
How to arrange two date difference in Datewise / Monthwise format in Different Cells And return periodic date matching data
I am attaching Excel Workbook for reference and Comments so You can understand my point of view properly.
Last edited by KRIXXXX; 06-26-2022 at 10:03 AM.
I do not understand your logic... but:
=IFERROR(B8-A8+IF(A9="NA",0,1),"")
in C8, copied down.
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
It's my mistake, after writing comments in worksheet, I deleted several rows, so it may be creating confusion, I have re uploaded new file.Originally Posted by Glenn Kennedy
Kindly first Read comments of Cell H1, H2 and H3. Then Cell D11 and after that Cell K7.
I think after that you can get what kind of output I Want.
Last edited by KRIXXXX; 06-26-2022 at 10:08 AM.
Try this. Differne shading = different formula. I'm not sure about column F, as you didn't explain it fully. However, your instructions to read the bits in a specified order helped enormously... thanks!!
Thank You, It works Very well.
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
I have already done both.
Previously you have provided the solution of above query, and this query is relates to this thread because its part contains your solution formulas, so I haven’t created new thread. But It’s more complex and very tricky.
I expect the results as shown in attached excel sheets Column AH (Cells AH3 to AH13)
Without doing calculations shown in Columns BE to DW
I mean if is there any way to combine all this Columns (Columns BE to DW) calculations in Column AH (Cells AH3 to AH13) only.
OMG!! You are expecting a lot.
One Q for now...
The date ranges are quite short. Some date ranges (columns D & E) straddle 2 price zones... For example this period: 29/09/2021 06/10/2021 covers two... 1.9 & 2.0. What is the MAXIMUM number of price zones that you expect the date ranges to cover? The time periods look like weeks... so I guess 2 is the likely maximum? yes?? No??
Problem!! I do not think that your expected results are correct.
I am focussing ONLY on row 7 to try to understand this. I chose row 7 because it straddles a price rise.
Look at the PURPLE cells. They are calculating the price for row 7 (I think) and it's differnet from your rather long-winded way. Can you doubke (treble) check and let me know if my sums are correct or not!!
The time periods look like weeks... so I guess 2 is the likely maximum? yes?? No??
It's in months, normally It's between 1 to 3 months, but is rare cases it can be upto 180 to 200 days also.
And in Cell BW18 it should be D7-D6
Dates in Column E are actually Due Dates.
Calculations are I have double checked.
Last edited by KRIXXXX; 07-24-2022 at 02:38 PM.
No. Surely it's 2 days @ 1.90 and 5 @ 2.00 It's absolutely not 33 days !!!
It was my mistake that I haven't cleared Column E, I extremely sorry for that. It created confusion.
Last edited by KRIXXXX; 07-25-2022 at 12:25 AM.
Sir,
Have you looked in to the issue
I got stuck. I will look again tomorrow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks