Need help with conditional formatting.
Closed
JessaSteele
-
Aug 11, 2016 at 12:37 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 11, 2016 at 02:52 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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!
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!
Related:
- Need help with conditional formatting.
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Formatting usb mac - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 11, 2016 at 02:52 PM
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
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
