Aug 12 2022 10:06 AM
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?
Aug 12 2022 10:15 AM
How To Add/Subtract Weeks To Date In Excel?
There are some formulas can help you add or subtract weeks to date in Excel.
Select a blank cell and type this formula =A1+7*2 into it, press Enter key and drag autofill handle over the cells which you need to apply this formula. See upper link.
Wish you a nice day.
NikolinoDE
I know I don't know anything (Socrates)
Aug 12 2022 10:29 AM
@NikolinoDE Thank you I can this a try adding *8 (for eight weeks) and replacing the cell A1 with my reference cell. Unfortunately it fails with the error value - The blank cell has been set to date as the format so unsure why its failing.
Aug 12 2022 10:37 AM
It works for me... should see the file... or it's about a pivot table.
Attached is my example in the file.
Aug 12 2022 11:17 AM
sry...here is the correct file with the change that no error appears if the cell is empty.
=IF(A1="","",(A1+7*8))
Aug 12 2022 11:34 AM
Aug 12 2022 11:52 AM
Aug 12 2022 12:04 PM