min date

Hi! I have a spreadsheet that we use to track contracts, Purchase orders, and Invoices/payments. I am trying to create a field that will show me the next soonest invoice date that doesn't yet have a dollar amount populated (because that date is the next invoice that we haven't yet paid... the...

Hi All, I have been racking my brain on this one and I can't seem to work out a way around it, so I thought I would put it to a wider audience. I have a 'Project Schedule' workbook in Excel 365 where you can have 3 types of groups. Stage, Task and Milestone. Each Stage needs to be able to...

I have 2 columns. Date and # of Safe Days The Date is starts on November 1 and is sequential through 2020. The Safe Days column represents a 1 or 0 0 = Not a Safe Day 1 = Safe Day I'm trying to figure out a calculation that will automatically give me the number of days since our last safety...

I have 2 columns. Date and # of Safe Days The Date is starts on November 1 and is sequential through 2020. The Safe Days column represents a 1 or 0 0 = Not a Safe Day 1 = Safe Day I'm trying to figure out a calculation that will automatically give me the number of days since our last safety...

Hello. I have a code to find min and max dates in Range("A") and Range("A2") and a MsgBox displaying min date(in format number) and another MsgBox displaying min date (in format number). This is my code and works fine: Sub minmaxdate() Dim rng As Range Dim ws As Worksheet Dim ch As...

Hello, I have a need in a pivot summarize one column by min and max date and another column by distinct count. In a default pivot the min and max date work fine but I cant get distinct count. So when I create the pivot in data model mode the distinct count works fine but now I can summarize...

I have an odd problem that has been plaguing me on a particular spreadsheet. I am hoping there is some funky setting somewhere that fix this that I have somehow screwed up. I have continual problems with date functions. Its as if the sheet will not recognize a data as a date. Its truly bizarre...

I use an array MIN formula too give me the earliest date from a set of data meeting one criteria. The dates are formatted as dates. ex: {=MIN(IF($D$2:$D$2222=$D2,$M$<wbr>2:$M$2222 ))} It works flawlessly and i understand what its doing. But when i try to use that method and add a 2nd...

I have three columns of dates. Each row corresponds to one item. I want to find the closest future date to today. So I used this =MIN(IF(G23:I23>$E$1,G23:I23)). However, for two items, the dates are all less than TODAY(). For that I would like to find the furthest past date from TODAY() that is...

Hello- I've been searching forums all morning trying to find a way to find a way to get the minimum value using two criteria. Here's a sample of what my data looks like, and ideally what I'd like to see as a result. <tbody> Case # Size Date 1 Small 201501 1 Small 201512 1...

I am using the MIN function for dates in two adjacent cells and it is returning 1/0/1900. How can I get the function to return one of the dates in the two cells selected?

Hello all. I want to use =MIN() and =MAX() to find earliest and latest dates in a very large range but cannot get a result, no errors, just empty cells! The date 'values' in the range are linked entries from another work book which I believe may be the cause of the problem. Is that the...

Hello, I have the following sample data set. I have a timekeeper lookup table with status (approved, etc.) linked to this data. I am trying to find the earliest date that each person worked, so that I can determine when each timekeeper started billing and if they are brand-new (i.e. not on...