date function

  • Thread starter Thread starter Allison
  • Start date Start date
A

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
 
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
 
Back
Top