Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel date formulas?
I have a date in a named cell called StartDay
from there I have a column that adds to the date
=IF(StartDay="","",StartDay)
=IF(C7="","",C7+1)
=IF(C8="","",C8+1)
=IF(C9="","",C9+1)
=IF(C10="","",C10+1)
etc...
I only want the formula to go as long as there are days in the month
if I entered 6/1/7
I only want the dates to show to June 30, not to July 1, because I would leave room if there were 31 days in the month.,
How can this be done??
VBA is no problem if that is the way to go...
3 Answers
- aladouLv 51 decade agoFavorite Answer
Try this formula:
=IF(C7="","", IF(DAY(C7+1)=1,"",C7+1))
(input at C8 and copy down)
Cheers.
.
- Don RLv 51 decade ago
It looks like you could add an If(AND(..... to your C column formulas for days 28, 29, 30,31.
You would have 3 sets of IF(AND in each formula. One for 30 day months, one for 31 day months and one for Feb.
You will have to play with leap year.
All the days up to 28th should be OK as is. Make sure you force blank cells in 29, 30, 31 when reqd.
If you have a prob with formula please email me.
- voyagerLv 61 decade ago
Here is the formula. See how it works for you.
IF(A1="","",IF(A1+1<=EOMONTH(A1,0),A1+1,""))
A1= Start date
Move the mouse over the formula so that you could see the whole thing.
