Hello all,
I currently use this formula:
="Day14 "&TEXT(A83+14,"mm/dd/yyyy")&" Day28 "&TEXT(A83+28,"mm/dd/yyyy")
Which will display Day 14 "date" Day 28 "date in my cell.
But i would like to have that cell blank whenever A83 is blank.
How do i incorporate the ISBLANK function in this formula, or is there another way to do this?
Thank you,
Bram
does this work for you
=IF(ISBLANK(A83),"","Day14 "&TEXT(A83+14,"mm/dd/yyyy")&" Day28 "&TEXT(A83+28,"mm/dd/yyyy"))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
It does work in an empty spreadsheet.
But when i download my current tabs from our Sharepoint server, the formula does not work
Last edited by bram89; 03-21-2016 at 09:55 AM.
should not do
if its text you will get a #value error
if a number it will use thats as a date
can you post a sample of your spreadsheet
It works now,
Thank you for your help!
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks