Need help with conditional formatting.

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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