++ 50 ++ excel today's date plus weeks 880531-How to calculate a date plus weeks in excel
I can get the formula to work for 1 set of dates in the future, as in due in the next 0 3 months, but I would also like to count (the same range) for ones that are due in 3 6 months only ie to NOT include those also less that 3 months The formula I was using is =COUNTIF (G9G23,"First we will apply the "Conditional Formatting" for (If the date I enter in Cell C2 is more than 60 days from Today) Enter the formula =AND (C2"", C2>TODAY ()60) Click on Format and select the green color Again we will click on "New Rule", New Formatting Rule dialog box will get appear, click on Use a formula to determine which Week ending dates don't have any dependencies, however can use a cell value as a date reference instead of hard coding the date Calculating which fortnight a date falls in relies on you having already set up a range of dates that the fortnight falls in Download the example workbook here Week Ending and Fortnight Ending Datesxlsx Week Pin On Tip...