01/01/1900

Hello I have only just started using this forum and I could really use some help. I am trying to create static timestamps in one column range "R" (R4:R56), dependent on/using a date entered in an adjacent column range "Q" (Q4:Q56) and data validation input in R. Using the data validation input...

Hi I was watching a video on how to subtract 1:00 am from 11:00 pm (cross midnight). So the author added 1 to the am time and then subtract it from 11:00 pm. Before adding 1 to 1:00 am, if I click on that cell I see in the formula bar 1:00:00 AM when I add 1, see 01/01/1900 1:00:00 AM...

Hi I have a cell D4 which has value = 40:03:28 The value is aligned to the right side of the cell, which gives me an impression it is a number, right? When I one click (select) that cell. I see the following: cell value = 40:03:28 Formula bar = 40:03:28 Home tab-->Number group --> I see...

Hi, Could I please ask for some help on a formula that works fine except when there is nothing to return =IFERROR(LOOKUP(2,1/(Update!$FL$3:$FL$5002=$B$1900)/(Update!$FO$3:$FO$5002=C1903),(Update!$FU$3:$FU$5002)),"") Unfortunately when B1900 and C1903 is blank this formula returns a date...

hi all: i comparing two table with formula: serial and Lot i used this formula: =IF(H2=0,IF(C2=I2,"match","not match"),VLOOKUP(H2,$B$2:$B$21,2,0)) column can be assumed as excel file. vlookup paste value, i want paste match or not match. kindly tell me is it possible with formula. i am using...

I have a series of data (c. 200k rows) with a sample below, and I'm after a formula that will give me the Min value for Start Date for each unique Item ID. I have used a formula (=days(today(),[Start-Date]) to calculate the days, but how do I identify only the min value for each of the SKUs...