Basically I'm calculating $0.75 for 6 days then on the 7th day it changes to $0.85 then 6 days later 7th day $0.95 and I need it to do it for 365 days.
I've tried
=IF(MOD(ROWS($B$1:B1), 6)=0.75,B1+0.1, B1)
and
=INT((ROW(B1)+0.1)/6)+0.1
and they work as they are supposed too, but my increments go from 0.75 to 1.75 to 2.75 and so on and the increments of 0.10 goes from 0.10 for 6 days to 1.10. But I need it to start out at 0, then 7th day .10, then 6 days 7th day .10 again.
Bookmarks