Date forumla

[red1702]

Look for a formula that will track the # of days open between two dates. Column 1 represents a RTW date and Column 2 is today's date. If today's date doesn't equal the RTW date, then the calculation period won't start.
but if RTW date and today's date equal the same, then I want to start the calculation period.

Column 1 Column 2 (Today's date)
5/31/2023 5/18/2023

 

[Joe4]

Welcome to the Board!

Can you show us a small sampling of different records and your expected results?
I am curious to see what you want/expect to see as dates pass.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.