Google Sheets - Min Date formula gone wonky

[spurs79]

Hi

I have a formula which on native Excel is fine but now has gone Wonky when I put in on Google Sheets. The aim of the formula is to search a list of orders and pick out the first date that rows customer made an order but its throwing up a random date which makes no sense.

Sheet link here https://docs.google.com/spreadsheets...it?usp=sharing

[janmorris]

access to file is denied. can you give access?

[spurs79]

If you request access I can grant it, I dont know how to make it public with an access request

[janmorris]

when getting the share link, simply change the setting to "anyone with the link can" .. "Edit".. or "View"

alternatively... provide a copy of an excel file, which i can then upload to google drive and work on solution.

[spurs79]

Done, new link attached

[janmorris]

great, thank you!

the problem appears to be that your dates in column I are actually text.

if you will be working with the data in both excel and google sheets, change the formula in I2 to :

Please Login or Register  to view this content.

and drag it down

OR, if you intend to work in Google Sheets only, then delete all the formulas from column I, and put this formula into I2 :

Please Login or Register  to view this content.

but do NOT drag it down


Next,

change your formula in M2 to be :

Please Login or Register  to view this content.

and the formula in O2 to be :

Please Login or Register  to view this content.

[janmorris]

corrections, due to rows with no dates:

if excel and google sheets:

Please Login or Register  to view this content.

and drag down

if google sheets only, in I2 :

Please Login or Register  to view this content.

and do NOT drag down

EDIT:

more corrections to accommodate for missing dates

in M2:

Please Login or Register  to view this content.

in O2:

Please Login or Register  to view this content.

[janmorris]

BONUS:

DATEDIF formulas are in the format of:

Please Login or Register  to view this content.

so Q2 should be :

Please Login or Register  to view this content.