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...
- Jun 25, 2024
Detlef_Lewin
Jun 25, 2024Silver Contributor
=LOOKUP(--"31.12.9999";G8:P8)
- Lisa_-_ExecAdminJun 25, 2024Copper ContributorThank you for a quick response. How does this help give me a date? I'm not as familiar with LOOKUP function.