Join 3 numbers to form a date

[rizmomin]

Hi :


I have 3 numbers in 3 column

Column D : 2
Column K : 1
Column L : 2012

I need 2/1/2012 in Column P...how would i do this..

Thanks

RM

[Leith Ross]

Hello Riz,

Place this formula where you need it. Change the cell references to what you will be using. Format the cell with formula to display the date in m/dd/yyyy format.

=DATEVALUE(D1&"/"&K1&"/"&L1)

[rizmomin]

Hi Leith:

Thank you ...this will work.
My purpose is to get a date range for semi-monthly pay period.
Can you have a look at attached Excel file "sheet3" to help me create date range as shown

Thanks a lot

Riz

[Leith Ross]

Hello Riz,

These formulas will calculate the beginning and ending dates from the table. The Year is taken from cell "$L$3". The day is from cells "D:J" and the month from "B".

(Column P) =DATEVALUE(B3&"/"&MIN(D3:J3)&"/"&$L$3)
(Column Q) =DATEVALUE(B3&"/"&MAX(D3:J3)&"/"&$L$3)

[Special-K]

in P3
=DATEVALUE("2012"&"-"&B3&"-"&MIN(D3:J3))

in Q3
=DATEVALUE("2012"&"-"&B3&"-"&MAX(D3:J3))

and copy down the columns

[rizmomin]

Hi Leith:

Thanks a lot ..this is great.

Hey Leith i wanted to create a Calender like what you see in the sheet.
I have created manually.
This is mainly to calculate overtime hours for Semi-monthly Payroll ( twice a month Pay, Paycheck 1-15 and 16 thru end of month).

Please help if u can..

RM