I want to have a parameter that selects the same month (which is September) every year. So this Parameter dynamically changes every year but still selects September.
Asked
Active
Viewed 46 times
0
-
1Something similar to this: =dateadd("m",1,dateserial(year(Today()),month(Today()),1)) but only selecting September as the month every year that is possible – Ron McArthur Jul 05 '17 at 02:45
1 Answers
0
It was all about changing the month the the static date. Took me a few tweaks but I was able to figure it out. It was actually pretty easy stuff. Feel free to post other methods. Method I used was:
=dateadd("m",-1,dateserial(year(Today()),9,1))
Ron McArthur
- 63
- 1
- 2
- 10
-
If this answer solves your problem please mark your answer as the solution to your own question. – OLIVER.KOO Jul 05 '17 at 04:29