Ageing

[nischal4487]

Hi,

I have a spreadsheet with dates on the column of the data I process. I would like to see the number of days starting from the date in a different column, please help
Thanks,
P

 

[Marcílio_Lobão]

nischal4487, Good evening.

Suppose:
A1 --> Your date

Try to use:
B1 --> Difference in days from your date and TODAY --> formula

B1 --> =TODAY() - YOUR DATE

Format B1 as NUMBER

Is that what you want?

I hope it helps.