Date formula

S

Seti

Hopefully this is an easy one for all of your excel guru's. I have a
cell called Date of Hire, I want the Date of Hire to populate another
cell with the first of the month following the date of hire. How would
I do that?

Thanks I really appreciate all the help this forum offers for people
like me who are lost in excel.

Thanks again!
Renee
 
B

Biff

Hi!

Try this:

Assume A1 = date of hire:

=IF(A1="","",DATE(YEAR(A1),MONTH(A1)+1,1))

Biff
 
Top