Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nett Date Calculation
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nett Date Calculation
=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 "Midas NDT Sales" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nett Date Calculation
try
=DATE(YEAR(G3),MONTH(G3)+1,1)+45 -- Don Guillett SalesAid Software "Midas NDT Sales" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nett Date Calculation
Date in A1
=DATE(YEAR(A1),MONTH(A1)+1,0)+45 -- Regards, Peo Sjoblom "Midas NDT Sales" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nett Date Calculation
Perfect,
Many thanks for all your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date difference | Excel Worksheet Functions | |||
Due Date Calculation? | New Users to Excel | |||
date and time | New Users to Excel | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |