Need help with conditional formatting.

Closed
JessaSteele - Aug 11, 2016 at 12:37 PM
Mazzaropi
Posts
1965
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 18, 2022
- Aug 11, 2016 at 02:52 PM
Hello,

I need to have my spreadsheet enter a date that is 6 months (180 days) from an original date once it is entered. I have 2 columns - Date Placed and End Date. I need my spreadsheet to auto populate a date in the End Date column once I place a date in the Date Place column. Also I need the cells that do not have a date entered into the Date Placed column to remain blank until one is entered.

Thank you!


1 reply

Mazzaropi
Posts
1965
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 18, 2022
146
Aug 11, 2016 at 02:52 PM
JessaSteele, God afternoon.

Conditional formatting works only for aesthetic characteristics of the cells.
This is not the case.

Suppose:
A1 --> Date Placed
B1 --> End Date --> Formula

Try to use:
B1 -->
=IF(A1="","",EDATE(A1,6))

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0