Thread: Bi weekly payments per month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Bi weekly payments per month

If your start date (15th April 2005) is in A2 and the first day of the
month you wish to check is in B2

=2+(DAY($A$2+28+CEILING(B2-$A$2,14))20)

e.g. in B2 September 1 2005 (format as "mmm-yyyy" if desired)
the above formula will give 3


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508557

Reply With QuoteReply With Quote