Days past todays date

[djaldente]

Hi,

I make 2 payruns per month, one on the 15th and one on the 30th.

I have the date the invoice was received in one column.

I would like to make a days overdue column based on todays date and the date of the corresponding payrun.

For example an invoice received on 12th March would be due 15th April & an invoice received on the 17th March would be due 30th April. So if todays date was 5th May the invoice would be 5 days overdue.

Thanks in advance

 

[etaf]

does this work for you
=IF(DAY(A2)<=15,TODAY()-DATE(YEAR(A2),MONTH(A2),DAY(15)),TODAY()-DATE(YEAR(A2),MONTH(A2),DAY(30)))
BUT invoices on the 31st of a month , I assume would be calculated from the 15th - is that so
in which case we need to add an OR to the test and add an extra month so its 15th of the next month - is that the case ?
And for FEB whoch is 28/29th what happens then

 

[djaldente]

does this work for you
=IF(DAY(A2)<=15,TODAY()-DATE(YEAR(A2),MONTH(A2),DAY(15)),TODAY()-DATE(YEAR(A2),MONTH(A2),DAY(30)))
BUT invoices on the 31st of a month , I assume would be calculated from the 15th - is that so
in which case we need to add an OR to the test and add an extra month so its 15th of the next month - is that the case ?
And for FEB whoch is 28/29th what happens then

Thanks for getting back to me mate, I managed to figure it out

 

[etaf]

you are welcome