Forum Discussion
Solved
Excel Formula Help with Calculating Dates
I have a column in a work sheet that has a Subscription Start Date, depending on that date depends on what is billed. Here is what I am wanting, I have tried different ways of writing this out and I...
=B1*IF(YEAR(A1)<YEAR(TODAY()),1,IF(A1>=DATE(YEAR(TODAY()),7,1),0,(7-MONTH(A1)))/12)
or, equivalently
=B1*IF(A1<DATE(YEAR(TODAY()),1,1),1,IF(A1<DATE(YEAR(TODAY()),7,1),(7-MONTH(A1))/12,0))
=B1*IF(YEAR(A1)<YEAR(TODAY()),1,IF(A1>=DATE(YEAR(TODAY()),7,1),0,(7-MONTH(A1)))/12)
or, equivalently
=B1*IF(A1<DATE(YEAR(TODAY()),1,1),1,IF(A1<DATE(YEAR(TODAY()),7,1),(7-MONTH(A1))/12,0))
Thank you! I will test it out. Thank you again!