Forum Discussion

Lisa_-_ExecAdmin's avatar
Lisa_-_ExecAdmin
Copper Contributor
Jun 25, 2024

EDATE formula for a range of cells

I'm looking for assistance with an Excel formula. I need to add 1 month to a date located in a specific row. Each row has a date in a different cell but always within the same column range. Dates are continuously being added, so the formula needs to dynamically adjust to identify the most recent date in each row and add 1 month to it.

 

In the example below, I need to add 1 month to L8, L10, K12, J14, K16, H18.  I want this date to show up in Column Q for each Outbound row.

 

 

 

 

 

Thank you in advance for your assistance! 

Resources