View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wf315 wf315 is offline
external usenet poster
 
Posts: 2
Default Date if before or after 15th of month

Hello-

My due date should be the 1st of the month if the start date is after the
15th or the 1st of the previous month if the start date is before the 15th,
but only if there is an amt in B7 otherwise blank.


B2=Start Date
B7=Amt
C7=Due Date