https://communities.sas.com/t5/SAS-Data-Management/Returning-a-blank-cell-when-data-is-not-inputted-yet/m-p/305999#M8752 <P>I would like the cell to return a blank when&nbsp;a date&nbsp;has not been entered yet for this formula but can not seem to complete this formula to accomplish this. Please help</P><P>&nbsp;</P><P>="QTR"&amp; INT((MONTH(Table2[@[Observation Date]])-1)/3)+1</P> Thu, 20 Oct 2016 16:46:54 GMT BeachJeep 2016-10-20T16:46:54Z https://communities.sas.com/t5/SAS-Data-Management/Returning-a-blank-cell-when-data-is-not-inputted-yet/m-p/305999#M8752 <P>I would like the cell to return a blank when&nbsp;a date&nbsp;has not been entered yet for this formula but can not seem to complete this formula to accomplish this. Please help</P><P>&nbsp;</P><P>="QTR"&amp; INT((MONTH(Table2[@[Observation Date]])-1)/3)+1</P> Thu, 20 Oct 2016 16:46:54 GMT https://communities.sas.com/t5/SAS-Data-Management/Returning-a-blank-cell-when-data-is-not-inputted-yet/m-p/305999#M8752 BeachJeep 2016-10-20T16:46:54Z https://communities.sas.com/t5/SAS-Data-Management/Returning-a-blank-cell-when-data-is-not-inputted-yet/m-p/306055#M8753 <P>Looks more like an Excel question than SAS. I would find a forum for Excel for this question.</P> Thu, 20 Oct 2016 19:29:39 GMT https://communities.sas.com/t5/SAS-Data-Management/Returning-a-blank-cell-when-data-is-not-inputted-yet/m-p/306055#M8753 ballardw 2016-10-20T19:29:39Z