software

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.
=EOMONTH(A1,0) 45
Format as Date

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

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

--
Kind regards,

Niek Otten

quot;Midas NDT Salesquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Can anyone suggest the answer to a simple problem, I want excel to
gt; calculate
gt; a nett date on an invoice.
gt;
gt; If I put a date in for example 16/12/2005 I want the sheet to return a
gt; date
gt; that is 45 days following the end of the month. Effectively the
gt; spreadsheet
gt; must jump to the end of the month and add 45 days to it. Hence the result
gt; will be the same if you enter 06/12/2005.
gt;
gt; Any help would be greatly appreciated.
gt;
gt;
try
=DATE(YEAR(G3),MONTH(G3) 1,1) 45
--
Don Guillett
SalesAid Software

quot;Midas NDT Salesquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Can anyone suggest the answer to a simple problem, I want excel to
gt; calculate
gt; a nett date on an invoice.
gt;
gt; If I put a date in for example 16/12/2005 I want the sheet to return a
gt; date
gt; that is 45 days following the end of the month. Effectively the
gt; spreadsheet
gt; must jump to the end of the month and add 45 days to it. Hence the result
gt; will be the same if you enter 06/12/2005.
gt;
gt; Any help would be greatly appreciated.
gt;
gt;
Date in A1

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

Regards,

Peo Sjoblomquot;Midas NDT Salesquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Can anyone suggest the answer to a simple problem, I want excel to
calculate
gt; a nett date on an invoice.
gt;
gt; If I put a date in for example 16/12/2005 I want the sheet to return a
date
gt; that is 45 days following the end of the month. Effectively the
spreadsheet
gt; must jump to the end of the month and add 45 days to it. Hence the result
gt; will be the same if you enter 06/12/2005.
gt;
gt; Any help would be greatly appreciated.
gt;
gt;
Perfect,

Many thanks for all your help.