Formula to capture data in a cell on last day of the month.
I'm trying to figure out a formula that will capture the data ($) that is in a cell (on another sheet) on the last day of each month. Is this even possible?
These are items that will move/change frequently so I just need to lock in the numbers at the end of each month and would prefer it to not have to be manual.
Can anyone help?
Help Article Resources
Check out the Formula Handbook template!