latest date

Hi everyone! I am new here in the forum and I looked for some solution to my problem and I did not find anything similar, so I decided to create a new post. I have a workbook with two worksheets "STOCK" and "SALES REGISTRATION". In Stock, I give all of my products that I buy to sell...

have two sheets > SALES! & stocks! date & code in SALES!$C$6:$C$5088 & SALES!$E$6:$E$5088 respectively date out & item code in stocks!$C$59$:$C$1887 & stocks!F$59:$F$1887 respectively once item code scanned into SALES!$E$6:$E$5088 the current date will appear on stocks!$C$59$:$C$1887 with this...

Hi everyone. I run a window cleaning company. I have two pages on my spreadsheet, one with a list of invoices, the other with customers. They usually have regular work. So I want a column in the customer sheet to be constantly looking at the invoice list. Everytime a new invoice is...

<colgroup><col span="3"><col></colgroup><tbody> A Cloumn` B Column C Column D Column Good 52 1 4/12/2017 0:00 Good 53 1 4/12/2017 0:00 Good 4234 1 4/12/2017 0:00 Good 5232 1 4/12/2017 0:00 Good 42342 1 4/12/2017 0:00 Good 24442 1 3/30/2018 0:00 Bad 41233 0 4/12/2017 0:00...

if I have 3 columns, date1, date2, and date3. I want to create a main date column with the latest of the 3 dates from the file. Is there an if statement to do that?

Hello Everyone ! I am a total noob to Excel. I've been slowly teaching myself the past 2 weeks. I have the below formula working with multiple conditions. =SUMPRODUCT((CompletionDate>=Z15)*(CompletionDate<= AA15)*Engraving) The CompletionDate is a range column of dates, Z15 is the cell with...

so I have used this formula in the past and just tested on another worksheet and its working fine.. but for some reason in my existing 2 comparison files, this formula is only coming back #n/a and I cannot figure out why. =MAX(IF('CC # to Customer Match'!$I$4:$I$3256='Customers with Card...

Hi. Can you help me solve this puzzle? Hope so. I've begun by showing the setup I have, but if you want to read the task and problem first, they're stated below. Tables have been stripped down to the essential columns; and cell references and sheet names have been simplified. SCENARIO / SETUP...

<TBODY> S# Product Shipment Date Rate 3 xyx 5-Jan-12 221 9 zzz 5-Jan-12 455 10 abc 5-Jan-12 5666 7 zzz 5-Feb-12 323 1 abc 5-Apr-12 1200 5 xyx 5-Apr-12 999 2 abc 5-May-12 333 4 abc 5-Jul-12 944 6 xyx 5-Aug-12 222 8 abc 5-Nov-12 123...

I have a data set with the following fields Date Member (3 specific members) Game (fixed list of 20 games) Score (integer) I want to use a pivot table to show which out of 2 of the members had the highest score in each game played at the most recent date. (Incidentally the games are all...

Is there a way for a cell to compute the latest date from other cells in the same column? This is so a fuel charge will always be activated by the latest date a client is serviced. I can get the techs to manually input the date, but would rather have it automated. Thanks for any help.