Formula to return next month and Year if min date returned inn Z1 is Sep

[howard]

I have dates in Col f. If the min Date returned contains Sep in Z1 for eg Sep-2020, then Oct-2020 to be returned

the min date should always be oct followed by the year

it would be appreciated if someone can assist me

formula to Return Next month if Sept is returned .xlsm

Shared with Dropbox

www.dropbox.com

 

[Fluff]

Does it matter which day it is?

 

[howard]

The day should be the 1st of the month

 

[Fluff]

In that case how about

=DATE(YEAR(MIN(F2:F100)),10,1)

 

[howard]

thanks Fluff. Formula works perfectly

 

[Fluff]

You're welcome & thanks for the feedback.