Tech Support Guy banner

Have 2 formulas in one cell and want to choice of which

1102 Views 4 Replies 2 Participants Last post by  excelhelp0809
Hi there,

I have 2 formulas in one cell and want a choice in which will populate.
EX. =DATEDIF(F12,TODAY(),"d") & "-" & DATEDIF(F12,G12,"d")
I want it to choose first formula if G12 does not have a date. REVISED: I am working on an on time delivery. I have the date the customer requested in "f" and I have the formula above in "g". "h" is the difference in days. If "F" (actual delivery date) is empty, I would like it to calculate the number of days with today's date (not really typed in cell). I would like the result to be 1 answer (either/or)

Not open for further replies.
1 - 5 of 5 Posts
=if(g12="", DATEDIF(F12,TODAY(),"d"), DATEDIF(F12,TODAY(),"d") & "-" & DATEDIF(F12,G12,"d") )
That still puts 2 answers in "h" column. I am looking for it to pick 1 if "g" is blank. If "g" is blank, I want it to use today's date.
not sure i understand now

=if( g12 = "" , today() , "now what formula to put here !")

so thats how you get today() if g is blank

now you have REVISED, and mention F

now if g is not blank - what do you want
Sorry, Please see line 13. once there is a date in "H", I would like there to only be 1 number in "I". Also if we ship early, is there a way to have negative days?


1 - 5 of 5 Posts
Not open for further replies.