| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Solve 1st of month after specified number of days elapsed
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
And the question is?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MH" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
Date + n - DAY(Date + n) + 1
Biff "MH" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
Or, for the 1st of the month for the *next* month:
=DATE(YEAR(Date + n),MONTH(Date + n)+1,1) Biff "T. Valko" wrote in message ... Date + n - DAY(Date + n) + 1 Biff "MH" wrote in message ... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
An employee becomes eligible for benefits on the first of the month following
a full 180 days of employment. I wanted to be able to enter the hire date and have a cell compute the eligible date. "Bernard Liengme" wrote: And the question is? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MH" wrote in message ... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
=DATE(YEAR(A1+180),MONTH(A1+180)+1,1)
-- David Biddulph "MH" wrote in message ... An employee becomes eligible for benefits on the first of the month following a full 180 days of employment. I wanted to be able to enter the hire date and have a cell compute the eligible date. "Bernard Liengme" wrote: And the question is? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MH" wrote in message ... |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
Thank you.
"T. Valko" wrote: Or, for the 1st of the month for the *next* month: =DATE(YEAR(Date + n),MONTH(Date + n)+1,1) Biff "T. Valko" wrote in message ... Date + n - DAY(Date + n) + 1 Biff "MH" wrote in message ... |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
Thank you.
"David Biddulph" wrote: =DATE(YEAR(A1+180),MONTH(A1+180)+1,1) -- David Biddulph "MH" wrote in message ... An employee becomes eligible for benefits on the first of the month following a full 180 days of employment. I wanted to be able to enter the hire date and have a cell compute the eligible date. "Bernard Liengme" wrote: And the question is? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MH" wrote in message ... |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Solve 1st of month after specified number of days elapsed
You're welcome!
Biff "MH" wrote in message ... Thank you. "T. Valko" wrote: Or, for the 1st of the month for the *next* month: =DATE(YEAR(Date + n),MONTH(Date + n)+1,1) Biff "T. Valko" wrote in message ... Date + n - DAY(Date + n) + 1 Biff "MH" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please Help With Days Elapsed And Days Remaining Calculation | Excel Worksheet Functions | |||
| Fuction that gives number of days of a given month | Excel Worksheet Functions | |||
| Number of Days in the Month | Excel Discussion (Misc queries) | |||
| formula for tracking number of elapsed days from a stard date | Excel Worksheet Functions | |||
| number of days in a month | Excel Worksheet Functions | |||
Linear Mode
