I have a spreadsheet which shows date in numerous cells in column B. In column A there is an IF forumla which calculates the number of days between the date(s) in column B and todays date (stored in C1).
My problem is that when I have need to insert a row (which is necessary sometimes) the inserted row no longer shows the formula in column A of that row. Is there any way that I could insert a row and somehow keep the forumula?
Any suggestions would be gratefully received.
Cheers
Simon
Bookmarks