Please take a look at the following:
2015-03-29 10_11_04-Microsoft Excel - Budget Management.xlsx.jpg
I have a spreadsheet for calculating finance where every line looks like this. I want to know if there is an easy way to control the calculation of data in the money cells based on a comparison to the current date and the first date of each line. In my example it is the 19th of march. What I mean is, I don't want any of the money cells to have any data, except maybe a "$ - ", unless the current day is on or after that first day. To continue with my example, since today is the 29th of March, which is after the 19th, there should be data in nearly all the cells, as you see in my example. However, a later line in my spreadsheet should have no data yet because the 9th of april hasn't passed, like in the manufactured example below:
2015-03-29 10_29_07-Microsoft Excel - Budget Management.xlsx.jpg
Lastly, if the only way I can do this is with adding a formula to each of my cells I don't really want to do that because it would making working with those cells kind of messy and inefficient for me. Is it possible to do that kind of conditional data entry for a group of cells? If so, of course, how do I do it?
Thank you for the help, I hope this is clear enough.
Bookmarks