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.

Lv 613,796 points

David M

Favorite Answers31%
Answers2,227

  • 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 AnswersSoftware1 decade ago