Ok...to give scenario
I need to subtract date of report from current date to work out how old the report is.
So Column A is date of report and I need to have a number of months (report age) in column B
I need to do this for multiple cells i.e. column A will have close to 200 dates
In other words...when I enter the date of report in column A I would like to have the number in column B that shows how long since the report was generated
So that's first part of the problem
Also, is it possible then to, based on the value in Column B to have like Column C which will have another value that will be calculated based on age of report
i.e. if report is more than 30 days old the value of 5 is automatically populated in column C
something like
if >1 then = 5
if >2 then = 10
if >3 then = 15
1,2,3 referring to number of months and values 5,10, 15 referring to auto populated column C
As in first case, I need solution for multiple entries
Thanks all for your help in advance
Bookmarks