Forum Discussion
Lisa_-_ExecAdmin
Jun 25, 2024Copper Contributor
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!
- Lisa_-_ExecAdminCopper ContributorYes! This absolutely worked, thank you so very much!
- Detlef_LewinSilver Contributor
=LOOKUP(--"31.12.9999";G8:P8)
- Lisa_-_ExecAdminCopper ContributorThank you for a quick response. How does this help give me a date? I'm not as familiar with LOOKUP function.