Due Date Formula

Hey everyone, I am setting up an invoice sheet and would like to have due dates automatically calculated. Payment terms are 30 days, irrespective of business days.


Say if in column A there are the issued invoice dates (ex. 27/06/2024), column B would have the due dates calculated, as per calendar dates.


I apologise if this is a simple question, but would appreciate your help. Thanks!

Posted on Jun 28, 2024 4:38 PM

Reply
Question marked as Best reply

Posted on Jun 28, 2024 5:14 PM

You only need to add 30 to the invoice date. For instance, if A1 contains the invoice date, the formula in B1 (the due date) would be:

A1 + 30
1 reply

Due Date Formula

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.