Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello guys,
I want to create a default bookmark for my sheet based on the current week, month and year.
I tried this in my filter:
= [Mydate= today() --> Works
=month[MyDate]=month(today()) -->wont work
and the same for year and week, but this wont work either. Does someone have any tips or tricks?
I could say that some format issue?
month(Date(Date#([MyDate], 'Your current format here')))=month(Date(today()) )