• kmunson
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 3
    Replies

Using the CloseDate + 60 formula, what is the Syntax for adding that the date must land on the nearest weekday? In other words, if 60 plus the close date results in a Sunday (Date), how do do I get the result to be Monday? 

Does anyone know how to create a formula field the adds 60 days to the close date. Seems straight forward but I keep receiving the error "Error: Formula result is data type (Date), incompatible with expected data type (Date/Time)." Help. 

Using the CloseDate + 60 formula, what is the Syntax for adding that the date must land on the nearest weekday? In other words, if 60 plus the close date results in a Sunday (Date), how do do I get the result to be Monday? 

Does anyone know how to create a formula field the adds 60 days to the close date. Seems straight forward but I keep receiving the error "Error: Formula result is data type (Date), incompatible with expected data type (Date/Time)." Help.