[Solved] What is the excel formula to find the upcoming Saturday a month?

by 


=EOMONTH(TODAY(),0)+7-WEEKDAY(EOMONTH(TODAY(),0)+7)

enter image description here

If you want it based on the current date, find the next first Saturday:

=TODAY()+7-WEEKDAY(TODAY()+7)

This will find the next first saturday of the month. So on the 6th of this month it will return 2/9/2017

enter image description here

3

solved What is the excel formula to find the upcoming Saturday a month?