Displaying the sheet names of mondays only

[wizzan1]

Hello!

I got help from "Olly" with this code thank you for this! - That returns the name or date of the last created sheet. What I would like to add is another function that returns the sheet name of the last created sheet on mondays only.
With other words, If a sheet was created this monday (November 4th) I want the function to return "Nov 4" until a new sheet is created next monday (November 11th).
Is that possible to do?

I've uploaded an example.

Best Regards!

Please Login or Register  to view this content.

[Trebor76]

Hi wizzan1,

Try this...

Please Login or Register  to view this content.

...which is called in the cell you want to see the result like so (change the OutputType to suit):

=LatestMondaySheet("dd/mm/yyyy")

Regards,

Robert

[wizzan1]

Hi Trebor

It works like a charm! Thanks alot.

[Trebor76]

Thanks for letting us know and marking the thread as solved