- Feb 5, 2006
- Office Version
Good day. I am running Excel out of Office365 (updated recently) on Windows 10 Home. I have a situation that will require a rather difficult formula. Is it possible to configure a column of cells to allow data entry by a user and have that data automatically modified by a formula? The end result of the formula would then be stored in the cell. I have a situation where the number of months of membership in a club is used to calculate a percentage of attendance in events based on the months of membership in a fiscal year. The fiscal year does not run from January to December which would make the situation much easier. I appreciate any help with this one.