#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Smartsheet Budget Formulas

Options
edited 12/09/19

Hi,

I would like to know the formula for the due date of every month to calculate the receivables and Payables.

For example, I have the data with amounts and due date of the payment. How can I input the formula, grab the amounts by the due date of every month. Please let me know.

Tags:

• Employee
Options

Hi Divya,

If your due dates change throughout each month, you can use this formula to see the sum total of what is due in the current week.

=SUMIF([Due Date]:[Due Date], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), Amount:Amount)

Or, were you asking for a calculation to create the due date?

Best,

Kara

This discussion has been closed.