View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PT40 PT40 is offline
external usenet poster
 
Posts: 7
Default Date Calcuation with Blank Cells

Hello,

I am looking to see if this is possible. I have my present formula below.
What I would like to do is that if the date in E2 is blank then to default to
6, and if not, then perform this calculation.

=DATEDIF(E2, TODAY(), "m")

Thank you