Hi! It's my first post to this forum and I'm really hoping someone can help me. In my head what I want to do is completely logical...so here it goes...
In my words: I want cell G2 to calculate a date 14 days after the date in D2 only if the cell E2 is null.
What i've tried based on other posts from this forum:
=IF(ISBLANK(E2), (D2+14)) and get FALSE.
=IF(ISBLANK(E2),"", (D2+14)) and get a random number that is nothing close to a date
Any ideas?? Any help is greatly appreciated!
Last edited by hrclark; 10-17-2011 at 11:29 AM.
Try:
=IF(E2="",D2+14,what_you_want_if_false)
You may have to format the result as text if you are seeing a 5 digit number...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I should note that in the first formula listed I have it using an E2 cell that is null. The second forumula I posted was on a cell that was not null (i.e. I wanted G2 to calculate a date 14 days past the date I put in E2).
NBVC you're awesome! That fixed my problem!!! I changed it to a short date!
THANK YOU!!!!!!!!!!!!
what's the number? remember excel store dates as numbers and displays them based on the number formatting options...(excel calls Jan/1/1900 day one and counts from there) today is 40,833)
So, if you are getting something like 40,0833...then Rightclick on the cell(s) you want to display this date and select a DATE format for the numbers.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks