How do you change this formula so it will return blank if there is no date entered?
DATE(YEAR(A7),MONTH(A7)+IF(DAY(A7)>17,1,0),17)
How do you change this formula so it will return blank if there is no date entered?
DATE(YEAR(A7),MONTH(A7)+IF(DAY(A7)>17,1,0),17)
What does it return now if a date is not entered? If it is an error, enter this into the cell that you place your formula:
Please Login or Register to view this content.
Right now its returning 1/17/1900... I replaced the formula to the one you said and it didnt make it blank. it stayed the same.. 1/17/1900
What is the date entered in A7
An alternative
=IF(A7="","",EOMONTH(A7,--(DAY(A7)>17)-1)+17)
Life's a spreadsheet, Excel!
Say thanks, Click *
Please see attached. I'm trying to set up a spreadsheet to track credit card bills. In this case, the bill cycle of this particular card is every 17th of the month according to the date entered. the thing is that when I dont enter anything, it should be blank.CREDIT CARD BILLS.xlsx
This might be what you are looking for.
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 10-20-2014 at 05:03 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Oh wow.. Doverman.. You're awesome.. Thank you.
Thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks