Re: plz help


What do you mean by "the month"?. Is it current month or value from the
column? You can enter formula to column where you want the result to be
written. Below is an example of the formula.

This assuming your date column is in A. Change the column to suit
yours. Don't forget to set your result column to date format (other
wise it'll only shows some numbers).

=IF(DAY(A1)>7,DATE(YEAR(A1),MONTH(A1)+1,DAY(22)),DATE(YEAR(A1),MONTH(A1)+1,DAY(7)))

Best regards.


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18903
View this thread: http://www.excelforum.com/showthread.php?threadid=398514

.

Relevant Pages

  • Re: can it be done without vb
    ... Regards ... spikk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24932 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Vlookup
    ... You helped me score some major brownie points with my boss!!! ... Best regards, ... akaramarkovic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24801 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: I am trying to set a letter grade for my students, HELP
    ... Please forgive for my bad English. ... hideki's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18903 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Hide/Unhide Rows
    ... Regards, ... Amber:) ... Amber_D_Laws's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30012 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Unicycling shoes
    ... Chrashing - Unicycles are flying machines! ... Regards, ... Chrashing's Profile: http://www.unicyclist.com/profile/7501 ... Prev by Date: ...
    (rec.sport.unicycling)
Loading