Date calculation

Alex77 ✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to use an Excel date-related calculation in Smartsheet and I'm having trouble translating it into Smartsheet. Any thoughts on the situation below? 

Column A (Deadline) is manual entry of Deadline date - no issue there.

Column B (Due in Next 60 Days) is supposed to return "TRUE" if the Deadline date in the row in Column A is not empty and is a date within the next 60 days of today (otherwise it returns FALSE). The formula used in Excel for this works, but I cannot get a similar formula to work in Smartsheet. The Excel formula that works is: