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)
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!