Hello everyone. I am writing a spreadsheet that is used for booking appointments in a doctors office and I want it to show amount of days since the patient has been initially seen. I have a formula that Subtracts the date seen from the current date, but it is producing a result even when a date seen is NOT put in the cell that the formulas is using to calculate the answer. I'm not sure what to do.
Last edited by JeJaOs; 10-24-2008 at 10:09 AM.
If your formula is:
=TODAY()-A1
You can change it to:
=IF(A1="","",TODAY()-A1
HTH
Jason
Can I submit my spreadsheet? New here and am still getting to know the furom...
Sure, attach it to the post.
Have a look in the "Weeks Wait" column and notice the answer without a date put in the date seen column.Have a look at L27 and see what you think of this formula. I appreciate your help. Thanks again.
Jeff
Hi Jeff.
By "date seen" do you mean "Date Consented"? If so, the formula you entered is correct, and you can copy it to the other rows.
Jason
Great! On the cell that I have the formula, there is a green corner? Is there a way to fix that? And yes....Date Consented is the right one. I just got up from working two full days on a job without sleep. Probably a typo or two thru these posts I would think.....
I fixed it. It was just an Excel note to tell me that the formula differs from the formulas in the rest of the spreadsheet. I deleted them and inserted this one in the other cells. Again, thanks so much for your help. My better half will now be able to use this at work. She thanks you too. Have an Awesome day!!!
Glad it helped.
Can you have a look at the conditional formatting in Column N and also the IF formulas in column N and see what you think? seems to kinda do the same thing as my date problem. Thanks :-)
here's the updated form.
Here you go.
Thanks Jason! I hope I can help you sometime...
Glad it helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks