spreadsheet

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

by

[ad_1] =EOMONTH(TODAY(),0)+7-WEEKDAY(EOMONTH(TODAY(),0)+7) 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 3 [ad_2] solved What is the excel formula to find the upcoming Saturday a month?

[Solved] How can I create a template that will auto populate/calculate cells based on a SKU value? [closed]

by

[ad_1] Turn your template into an Excel Table using the Ctrl + T keyboard shortcut. These have calculated columns that autofill formulas, and the tables themselves auto expand to accommodate new data. 0 [ad_2] solved How can I create a template that will auto populate/calculate cells based on a SKU value? [closed]