how do i write a formula that determines the # of days remaining in the year from the current date in excel?

by

on excel . please help 🙁

✅ Answers

? Favorite Answer

  • set cells A & A to date format. Set one cell to the last date of the year eg cell A to –. in cell A type =TODAY() this puts today’s date in cell A. then in a third cell format it to a number with no decimals and simply type the formulae = A-A

  • =DATEDIF(TODAY(), DATE(YEAR(TODAY()), , ),”ym”)&” months, “& DATEDIF(TODAY(), DATE(YEAR(TODAY()), , ),”md”)&” days.”

    or

    =DATE(YEAR(TODAY()),,)-TODAY()

    format the cell containing this formula to “General”

    • Leave a Comment