Date Calcuation with Blank Cells

P

PT40

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
 
R

ryguy7272

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

Regards,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple functions, conditional functions 7
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
HELP! I need to make an IF Statement comparing date/time fields.. 2
Counting cells in a selectable date range 0
sumif returns blank if all cells blank 7
IF and dates 7
Percentage Formula 4
How do I average cells that contain #DIV/01? 2

Top