I have a column of dates in a table. I am looking for a formula to return the lowest day in the earliest month in the column. for example if the earliest month is September i want to formula to output 9/1 of that year. If the earliest month is January then i want the output to be 1/1 of that year.
Thanks in advance
D1 is an array formula, confirm with CTRL+SHIFT+ENTER not just ENTER
Please Login or Register to view this content.
This requires that you pick a specific year as input in cell C1.
Does that give E1 as the output you are looking for?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
sorry should have clarified. I do not want to have to put a year into C1. The dates in column A are in the format 1/1/2015, 7/25/2015, etc.
Please Login or Register to view this content.
Ben Van Johnson
This will give you the earliest day of the earliest month not including the year. The dates are in random order in A1:A4. The range must not include blanks.
Formula:
Please Login or Register to view this content.
Enter with Ctrl + Shift + Enter
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks