| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculating payment terms "End of Month +30".
Hi All,
I am trying to have a formula that will calculate the due date on invoices that have payment terms "End of Month +30". e.g. Invoice date May 7th, then the formule shoudl calculate 30 days from the end of May. The invoice date is in the following format 07/05/2012. I have been breaking my head over this. Please help. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| How to include boilerplate "terms of sale" below range | Excel Programming | |||
| Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
| Working out age from "Day" "Month" "Year" | Excel Worksheet Functions | |||
| Convert "Month" to "MonthName" format from db to PivotTable | Excel Programming | |||
Threaded Mode
