Excel formula for days between two dates

[Robertson1995]

Hello. I am needing a formula that calculates how many days there are between today and a previous date. The previous date is in Col G. I need the number of days between the previous date and today to be in Col H. I need this to be static though so if the previous date is 01/01/25 and today is 01/10/25 making the days between 10 is there a way to keep it from changing to 11 days tomorrow? Thanks in advance for any help.

 

[alansidman]

so long as you are not using today() or now() then this link will work for you.

MS Excel: How to use the DATEDIF Function (WS)

This Excel tutorial explains how to use the Excel DATEDIF function with syntax and examples. The Microsoft Excel DATEDIF function returns the difference between two date values, based on the interval specified.

www.techonthenet.com

 

[Robertson1995]

That worked. Thanks for your help.