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

Date Calcuation with Blank Cells
 

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PT40" wrote in message
...
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

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

Date Calcuation with Blank Cells
 

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

Tyro

"PT40" wrote in message
...
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

Date Calcuation with Blank Cells
 

=IF(E2="",6,DATEDIF(E2, TODAY(), "m"))
--
David Biddulph

"PT40" wrote in message
...
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

Date Calcuation with Blank Cells
 

Yes, that was perfect. Thank you

"ryguy7272" wrote:

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