Formula to calculate difference between todays entry and the entry from 30 days ago
Hi, I am trying to create a column that contains the difference from the number in the cell entered today and the number in the cell entered 30 days ago. The columns are dates.
i.e Column 7/1/22 Row 2 = 10, Column 6/1/22 Row 2 = 50. Difference Column Result: 40
And really, since "30 days ago" may not have been a business day and may not have a column, so I really need it to look at the 30th column (if that makes ANY sense).
Help Article Resources
Check out the Formula Handbook template!