Solved: How to merge datedif with if function..

Create Account

Microsoft Excel

Questions

Followers

Top Experts

MushroomJ

How to merge datedif with if function..

Hi....

I would like to ask how to hide the date result if there is no value in the cell which is being stated...
I do not know how to state it.. the encircled formula is not working....

Thank you...

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

D Patel🇮🇳

On the Home tab, click the Dialog Box Launcher Button image next to Number.

In the Category box, click Custom.

In the Type box, select the existing codes.

Type ;;; (three semicolons).

Click OK.

D Patel🇮🇳

=IF(R17>=1,0,DATEDIF(R17, TODAY(), "D")/7)

Use this

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)🇮🇳

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

crystal (strive4peace)

if a cell is blank, Excel assumes it is a zero-length string so compare to ""

if(R17<>"",what-you-want, 0)

Open in new window

then you can format 0 not to show ... or use (if it won't mess with formulas) :

if(R17<>"",what-you-want, "")

Open in new window

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Subodh Tiwari (Neeraj)🇮🇳

@Crystal
Please open a blank workbook, and on Sheet1, in T17, place the formula you suggested i.e.
In T17

=IF(R17="","",DATEDIF(R17,TODAY(),"d")/7)

Open in new window

Now input a text string (not a date or number) in R17, what do you get in T17 then?

MushroomJ

ASKER

Thank you for the formula Sir... It works.....

Subodh Tiwari (Neeraj)🇮🇳

You're welcome. Glad to help.

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

crystal (strive4peace)

oops! forgot the leading = (mostly use Access but do a LOT with Excel though automation) ~ thanks, Subodh

Subodh Tiwari (Neeraj)🇮🇳

@Crystal

No you didn't get my point. I was not talking about that and I assumed it as a typo. :)
Did you follow my request from Post ID: 41804234?

crystal (strive4peace)

thank you, Subodh and please pardon me, as I was speaking generically since I prefer to teach rather than do completely. what-you-want would be substituted for the formula -- and obviously, a user function or function from an add-in pack is being used.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Subodh Tiwari (Neeraj)🇮🇳

You're welcome Ctystal!
I am well familiar with your profile and your capabilities. :)
And I know that you are a good teacher as well. :)

crystal (strive4peace)

thank you, Subodh

crystal (strive4peace)

Namaste

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Subodh Tiwari (Neeraj)🇮🇳

Wow.... Namaste Crystal!

In Hindi (Indian language)
नमस्ते क्रिस्टल! :)

Microsoft Excel

Questions

Followers

Top Experts

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.