If than formula using dates

[GORD.FR2]

I have a spreadsheet in which row F is the original hire date, and row H is the last check date, I need to insert for row G a project start date based on the following- if the hire date is before 1/1/12 than the start date is 1/1/12, if the hire date is after 1/1/12 than the start date equals the hire date.. I cannot seem to get the formula to correctly show the hire date as the start date when the hire date is after 1/1/12. Pls advise

[Andrew-R]

Assuming your first row is row 2 then:

=MAX(F2,40909)

[Fotis1991]

=if(f1<40909,40909,h1)

[Richard Buttrey]

Hi,

One way in H2

=IF(F2<DATE(2012,1,1),DATE(2012,1,1),F2)

Are you sure your cut off date is correct? i.e. over 12 months ago

[GORD.FR2]

Richard, the cut-off date is good, since the spreadsheet is being used for a future projection. I had tried yr formula last night, and it places the hire date in the column for start date.
I.E. if the hire date is 7/13/12, than the formula reflects a start date of 7/13/12 conversely, if the hire date is 12/22/11, instead of depicting a start date of 1/1/12, the hire date remains 12/22/11

I can't seem to have the formula show a start date of 1/1/12 for anyone with a hire date before 1/1/12..

[GORD.FR2]

Andrew, the formula generates only 1 outcome, all start dates are 1/1/12 which is fine for any hire date prior to 1/1/12, but invalid for hire dates after 1/1/12

[Andrew-R]

All three of the formula posted in this thread should work fine.

Can you post an example workbook, please?