date function

[Allison]

I am currently trying to compute an employees' hire date
plus 90 days, then from that date compute the first date
of the next month.

Currently this is what I have done to compute it, but it
seems that there must be an easier way.

Take the date hired (6/18/04) and using the =month,
returning the month number (6). Then I add 3 to that
number (9), and then do a vlookup to turn 9 into 9/1/04.
This works, but the user would have to keep updating the
vlookup range to the correct year.

Is there an easier and better way? Thanks Allison

 

[Peo Sjoblom]

Assuming that you should use 3 months,

=DATE(YEAR(A1),MONTH(A1)+3,1)

with the hire date in A1

however if it is 90 days what would you expect if the hire date is 06/01/04,
90 days plus
is 08/30/04 and the first day of that month is 08/01/04? If that's
expectable

=DATE(YEAR(A1+90),MONTH(A1+90),1)

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom