Thread: Entering date in cell need to show bi-weekly paydate in another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
protonLeah
 
Posts: n/a
Default Entering date in cell need to show bi-weekly paydate in another

Assuming paydys are around the 1st and 15th, something like:
=IF(DAY(A1)15,A1+30-DAY(A1)+1,A1+15-DAY(A1))
should get you in the right direction...


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=543978

Reply With QuoteReply With Quote