Formula for autocalculating difference based on current and previous day

Hello,

Friends, I'm in a big need for a formula wich need to calculate how many days remain until the membership expire.
For example, the membership is for 30 days. I want everytime I open the excel file with the table wich contain clients and their
memberships, i want everytime that the cell read the actual time and date of smartphone (if excel file is opened on smartphone) or PC (if it's opened on PC)
and auto adjust the remaining days.

Please check the picture below with aditional explanations.

Very much thanks for any help!

You can use this formula in cell Q8:

=IF(DATE(O8,N8,M8)<=TODAY(),"Overdue",DATE(O8,N8,M8)-TODAY())

Format the cell as General, then copy down. You may need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Hope this helps.

Pete

Hi Pete,

It work flawless!
Thank you very much!