Listing evaluation dates as the 1st of the month.

[windrain]

I am trying to create a simple spreadsheet for evaluation dates. I have used conditional formatting to alert when the date is coming up. Evaluations are based on hire dates and they are every year due during the month they were hired. In my attached spread sheet column C is the hire dates. In column "D" I am trying to do a formula so that the evaluation day is 1 year after hire and then changes to the next year when it passes. So far I have used
=EDATE(C4,12*(DATEDIF(C4+1,Today(),"Y")+1))
However what I am trying to do is have the evaluation days all change to the first of the month of hire date. If hire date is 7/25/2015, the first evaluation due date would be 7/1/2016 and so on. I hope this makes since.

Any suggestions would be very appreciated.

[Tony Valko]

I didn't download your file.

Assuming your formula is correct but needs tweaked to return the 1st of the month date...

=EOMONTH(EDATE(C4,12*(DATEDIF(C4+1,TODAY(),"Y")+1)),-1)+1

[windrain]

Thank you! That works perfect. I have one more question I didn't realize before. If I haven't entered a hire date, (cell is blank) in the evaluation cell it is putting 12/1/15 as a date instead of leaving it blank also. It was doing this before I put in the new formula, I just didn't see it.
Thank you again!

[Tony Valko]

Maybe this...

=IF(C4="","",EOMONTH(EDATE(C4,12*(DATEDIF(C4+1,TODAY(),"Y")+1)),-1)+1)

[windrain]

That works perfect.

Thank you so much!

[Tony Valko]

You're welcome. Thanks for the feedback!