Forum Discussion
Excel Formula
need formula to find days took between 5 different dates from cell A with cell C, D,E and F also if any of the date closer to the date of A then calculate the days.
From the brief description you give, it's hard to do anything elegant. But a simple formula like this will calculate the number of days between cell A2 and B2 through F2 (just copy the formula from B2 into those other cells)
=ABS(Days(B2,$A$2))
You can then find the minimum number by formula using =MIN(B3:F3)
By the way, the ABS in that first formula just gives an absolute (always positive) number... so it is the number of days in either direction from A2...
If you need more help, please post a more complete description, or perhaps a sample of the spreadsheet you're working on.
=ABS(Days(B2,$A$2))
You can then find the minimum number by formula using =MIN(B3:F3)
By the way, the ABS in that first formula just gives an absolute (always positive) number... so it is the number of days in either direction from A2...
If you need more help, please post a more complete description, or perhaps a sample of the spreadsheet you're working on.
- I am looking for a complex calculation
If A _ Conf. Delivery date
B_ received at store
C received by client
D in transit by stores
Now need to calculate days took to deliver.
From A (if any of the B,C,D cell have value or if any of the cell is near to the date of A. Means Lowest date to be picked n calculate.Rekha354 Could you give some examples with data from real life, along with a description of the calculation you would do if you were doing it "manually" --- it's clear that you know what you mean, but your description, frankly, is not as clear as a complete example would be. Preferably several examples, maybe with one of them being an "out-of-the-ordinary" situation.
Words alone are just naming the variables, but not actually describing what you're asking to do with them, except that it's clear you want to know how to calculate numbers of days between various dates....but it's also clear that's not all that you want.
- Good Day,
Please see the real date witch highlighted comments for formulas.
Hope this will give you a clear picture of my requirements.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC
Buyers Ship-Name User ID Ref. Bid closing
Date Status date Order-type-Desc Status Supplier PO.Date Base Curr. Est.Amt.Bas Order conf.date Days for PO ACK Real del.date Company Quotes
Sent/Rec Type Pri. text Sent Ship Rec. storage Year Rec.ship Pay date Days for PO Acknowledge Open Requisition Delayed Delivery
HAD TUGS HAMD TU-19-5015 13-01-2019 13-03-2019 OTHERS ORDER COMPLETED TER SERVICES COMPANY 13-01-2019 QAR 12,065.52 13-01-2019 15-01-2019 30-01-2019 1 (1/1) P URGENT 24-01-2019 2019 28-01-2019 10-04-2019 calculate days from PO Date J to Order cof. Date(M), also need to check networking days & if any holidays inbetween the days. from O I need to check (T,U,W) If any of the cell missing consider other cells, In this example T is lesser value ) so can take T and complet the calculation.
AAD PILOTS AMA PB-19-5016 13-01-2019 02-04-2019 SPARE PARTS ORDER COMPLETED ASR MACHINERY 13-01-2019 QAR 2,167.50 13-01-2019 13-01-2019 30-01-2019 1 (7/4) P URGENT 14-01-2019 2019 16-01-2019 31-03-2019 calculate days from PO Date J to Order cof. Date(M), also need to check networking days & if any holidays inbetween the days. from O I need to check (T,U,W) If any of the cell missing consider other cells, In this example T with no value & U & W with values, nearest value is U ) so can take U and complet the calculation.
RDA 55 TUGS REDA SB-19-5228 22-10-2019 15-10-2019 OTHERS INQ SENT 15-10-2019 QAR 1 (1/0) I NORMAL 2019 we used to segrete each status Cell H will represent and will count delayed days From today last action will be caluated from Cell F ( if any holidays or weekends that will be considered
SED 55 TUGS SRED NB-19-5229 27-10-2019 OTHERS QUOTES RECEIVED 16-10-2019 QAR 1 (9/4) I NORMAL 2019 we used to segrete each status Cell H will represent and will count delayed days From today last action will be caluated from Cell F ( if any holidays or weekends that will be considered
