James Perry
Member
I was doing a hypothetical ageing analysis of debtors.
Typically one would use the =(TODAY) function as a base date even in a real-life situation.
But in order to insert a fictitious date in the 'Bill Date" column i used.........
=(TODAY) -10, =(TODAY) -15, =(TODAY) -20 and so forth.
That way i was able to insert about 50 dates effortlessly.
Typically one would use the =(TODAY) function as a base date even in a real-life situation.
But in order to insert a fictitious date in the 'Bill Date" column i used.........
=(TODAY) -10, =(TODAY) -15, =(TODAY) -20 and so forth.
That way i was able to insert about 50 dates effortlessly.