Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date question in Excel 1

Status
Not open for further replies.

kabushnell

Technical User
Jun 4, 2003
81
US
I am trying to determining if a date occurred in the first or second half of the year using Excel based on the day and month. The years are all different but they are not pertinent.

Does anyone know some type of formula that will return a value that I can determine whether or not the date was in the first or second half of the year?
 
If it only matters that the date is before July 1st:
=IF(MONTH(A1)<7,"1st","2nd")

Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top