Formula calculating start/end dates using today and Blank if no dates
Hello,
I am looking for a Formula for calculating the days between a start and install date (end date), while using “TODAY” as the end date calculation if there is no end date yet. If there is no start date yet, because there is no job in that cell yet (wanting the formula ready for when there is) that it will leave that field blank until a start date has been entered.
Start date = F6
Install Date (end date) = G6
Job Length (formula cell with blank option) = H6
Thanks in advance!!
welcome to the forum. how about:
=IF(F6="","",IF(G6<>"",G6-F6,TODAY()-F6))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I think we’re close, it says “42d” and when I drag down the formula, they all say 42d and cell formula are the original paste reference, it doesn’t change to the new row.
This is what I wrote that was generating an in correct length answer:
IF(G6=“DATE”,G6−F6,TODAY()−F6)+IFERROR(F6=“BLANK”,“BLANK”)
In numbers <> is showing up as ≠....could that be the issue?
do upload an excel sample so that we do not have to manually key in your data to do a testing.
input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.
the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.
try to use the solution i have given and we'll help to advise what went wrong.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks