Forum Discussion
FORMULA TO ADD 8 WEEKS FROM A DATE WITH CONDITIONAL FORMATTING
Evening - I would like to set a formula to add 8 weeks from a date in another cell - I would ideally like this to turn red if it exceeds 8 weeks. Looked online and cannot fathom it out anyone help?
Unfortunately, without a file or a picture of the error, I can't help you further. Recommend inserting the file (without sensitive data). Or you can send me a private message (see my profile) to see where the problem might be.
One possibility would be that the date is in text and should be converted to a number.
Select the date range
Right click and select "Format Cells...".
In the Number menu, select Left Default or Number,
OK...thus the text would be converted to a number and the formula should work.
Select the date range
Right click and select "Format Cells...".
In the Number menu, select Left Default or Number,
OK...thus the text would be converted to a number and the formula should work.