Dragging down date formulas

Options

I am trying to drag down dates to populate year days using formulas. It does not go to the next day using drag down. Is there any trick to it? Here is the example


Date1= 01/01/2020

First Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 1) = 01/01/2020

Second Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 2) = 01/02/2020

Third Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 3) = ......


thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!