Get instant live expert help on How do I calculate due date in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
how to calculate days past due from due date till todays date
Solved by F. S. in 28 mins
Hi I need to calculate a due date from the invoice date. However the due date is always the 7th of the 2nd next month. For example if we in voice on the 14/01/2018 the due date will be 7/03/2018. Another example 29/03/2018 the due date will be 7/05/2018
Solved by S. L. in 12 mins
working on an income sheet for a small care home. so i need to calculate monthly income. i have start date, then a column for next payment date (28 days) but i also have an end date (if resident moves out) so if the end date falls before the due date, then i need the due date to be accurate and calculate the correct number of days
Solved by A. C. in 23 mins
hi, i have a spread sheet which show's a calibration date and a calibration due date. I'm trying use conditional formatting to high light the calibration due date in yellow when its 30 days, orange 15 days to due date and past due date in red.
Solved by V. F. in 20 mins
Column A "Date Received" Column C "Priority" is validation list with options P1-P6 Column D "Due Date" .. How do I make Column D calculate the due date, based on which option is selected in Column C in conjunction with the date in Column A? PI = Date Received P2 = Date Received P3 = Date Received + 1 day P4 = Date Received + 5 business days P5 = Date Received + 14 business days P6 = Date Received + 30 business days
Solved by D. U. in 14 mins