Date formula
 

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

Nevermind - I figured it out! Thanks!

Date formula
 

Hi!

Try this:

Assume A1 = date of hi

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

Biff

"Seti" wrote in message
...

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




--
Seti