date calculation

  • Thread starter Thread starter Kieran Moloney
  • Start date Start date
K

Kieran Moloney

I need an excel formula to work out the following;

The payment date is the first business day of each month, the calculation
date is the fifth business day immediately preceding a payment date.

When I enter the payment date I want the formula to calculate the
calculation date ( Need to exclude weekends)

thanks
Kieran
 
=WORKDAY(A1,-5)

this is from the Analysis Toolpak, so make sure that is installed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Business working days & Cash FLow 2
Loan Calculation 2
Date function within loan amortization spreadsheets 3
SUMIF using date ranges & referencing account numbers 1
Calculations 3
CUMIPMT 0
Calculate Payment Days and Date 3

Back
Top