View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Date Calcuation with Blank Cells

Hope this does what you want:
=IF(E2="",6,DATEDIF(E2,TODAY(),"m"))

Regards,
Ryan---

--
RyGuy


"PT40" wrote:

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