Please help!!
I am looking to create a formula in my spreadsheet which will calculate some dates for me firstly I want to calculate a formula from a start date plus 6 weeks and then from there format the cells so if that date goes two days over it turns amber then red if 3 days over? does that make sense?
I am getting nowhere fast but i'm not an expert on different formulas unfortunately.
Cheers all
I am looking to create a formula in my spreadsheet which will calculate some dates for me firstly I want to calculate a formula from a start date plus 6 weeks and then from there format the cells so if that date goes two days over it turns amber then red if 3 days over? does that make sense?
I am getting nowhere fast but i'm not an expert on different formulas unfortunately.
Cheers all