Excel formula help needed

[overmyhead1]

I'm not sure if this is possible. I am looking for a formula to populate column d 30 days in the future based on a date either put in columns a, b, or c. Also, is a way to lock column d's original date, if another date is entered in another column later.

For example: I enter today's in column b. Column d will auto populate 30 days in the future. Over the next few days I enter dates into columns a and c, but I don't want column design original date to change.

Is there a formula for all this?

 

[Holger]

are the dates entered into a, b, c sequential, meaning is the date in b later than a and c later than b and a? If so, you can simply use below, assuming your dates are in row 1.....

=MAX(A1:C1)+30

 

[overmyhead1]

are the dates entered into a, b, c sequential, meaning is the date in b later than a and c later than b and a?

The dates could all vary on what gets entered into a, b or c. I guess another way to ask my question is the ealiest date entered into a, b or c will need to show 30 days in the future in d. However I will eventually need to put other dates in the other 2 columns at a later date without changing d's original date.

 

[Holger]

if you are after 30 days from earliest date entered change the above to:

=MIN(A20:C20)+30

 

[overmyhead1]

if you are after 30 days from earliest date entered change the above to:

=MIN(A20:C20)+30

How would I hide the date that populates in my spreadsheet until a date is entered. When i put this formula in, column d is showing 1/30/00. This number changes when I enter my data, but I would rather have a blank spreadsheet until data is entered. Thank you for your help!

 

[Holger]

I’m off computer due to Timezone difference but firstly may I suggest you use xl2bb tool to post a snippet of your data. Further from your comment it looks it might be due to diff between mine and your date format. I use dd/mm/yyyy while it looks like you might be using mm/dd/yyyy.

See if that works please.

 

[overmyhead1]

The formula works but how would I hide the 1/30/00 date until I enter a date in the other columns? Thanks

 

[Dave Patton]

=IF(COUNT(C2:E2),MIN(C2:E2)+30,"")

 

[overmyhead1]

=IF(COUNT(C2:E2),MIN(C2:E2)+30,"")

Thank you!

 

[Joe4]

overmyhead1,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.