You need to sign in to do that
Don't have an account?
David Rightscorp
calculate amount of days in month
I need a formula that calculates how many days are in the current month.
I've been using this: DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1)
till now but it's starting to give me an error: #Error!
HELP!
I've been using this: DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1)
till now but it's starting to give me an error: #Error!
HELP!
IF(MONTH(TODAY()) = 12, 31, DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1))
All Answers
IF(MONTH(TODAY()) = 12, 31, DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1))