Need values for dates

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
W

Wayne Burritt

Hi: I have the following formula in a number of cells across a row. It
returns a declining series of dates, which I've formatted in YYYY. It works
great -- thanks to this newsgroup! The problem is I need to copy and past
the cell contents -- which in this case is "2004" -- as values. But when I
copy and paste special as values I get "38076", the dates numerical value.
Is there a way to copy and paste the cell so that the target cell actually
contains "2004"? Thanks. Wayne

=DATE(YEAR(Q20),MONTH(Q20)-3,30)
 
Back
Top