Nett Date Calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Midas NDT Sales - 16 Dec 2005 16:13 GMT

Hi,

Can anyone suggest the answer to a simple problem, I want excel to calculate
a nett date on an invoice.

If I put a date in for example 16/12/2005 I want the sheet to return a date
that is 45 days following the end of the month. Effectively the spreadsheet
must jump to the end of the month and add 45 days to it. Hence the result
will be the same if you enter 06/12/2005.

Any help would be greatly appreciated.

Reply to this Message

Niek Otten - 16 Dec 2005 16:24 GMT

=EOMONTH(A1,0)+45
Format as Date

Or, if you don't have Analysis Toolpak installed,

=DATE(YEAR(A1),MONTH(A1)+1,0)+45

Signature

Kind regards,

Niek Otten

> Hi,
>
[quoted text clipped - 10 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

Don Guillett - 16 Dec 2005 16:25 GMT

try
=DATE(YEAR(G3),MONTH(G3)+1,1)+45

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 10 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

Peo Sjoblom - 16 Dec 2005 16:43 GMT

Date in A1

=DATE(YEAR(A1),MONTH(A1)+1,0)+45

Signature

Regards,

Peo Sjoblom

> Hi,
>
[quoted text clipped - 7 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

Midas NDT Sales - 16 Dec 2005 17:26 GMT

Perfect,

Many thanks for all your help.

Reply to this Message