Hi all,
I am likely not searching in the most efficient way but am not finding the solution to my problem.
I am trying to write a formula that will identify a date, within a list of daily dates (4/2/16, 4/3/16, etc.), that would be the month end (and quarter end) and apply a separate formula to it.
I.e., =IF(9/30/16 is a month end date, 1, 2)
I suppose I could build a table of month and quarter end dates and then say if this value appears in this table, then 1, otherwise 2. Not even sure how that formula would go
Thank you
Troy
I am likely not searching in the most efficient way but am not finding the solution to my problem.
I am trying to write a formula that will identify a date, within a list of daily dates (4/2/16, 4/3/16, etc.), that would be the month end (and quarter end) and apply a separate formula to it.
I.e., =IF(9/30/16 is a month end date, 1, 2)
I suppose I could build a table of month and quarter end dates and then say if this value appears in this table, then 1, otherwise 2. Not even sure how that formula would go
Thank you
Troy