Joined: 24 Nov 2009
Location: United States
Online Status: Offline
Posts: 4
Topic: Date Formula Posted: 24 Nov 2009 at 4:00pm
I need to display in a report due dates of invoices. The formula that I need is to use a date, add 45,60, or 90 days, and the due date is the end of that month (after adding the days.) For example, 60 days from Nov 24 is January 24, so the due date that should be returned by the formula is January 31.
Another term that needs to be accounted for is adding 90 days to the date, and the due date will be the next 10th of the next month. For example, date is November 24, adding 90 days gets February 24, so the due date would be March 10.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
