Here are some problems that our users have asked and received explanations on
How can add x Months from a beginning date to "now" on an ongoing basis?
Solved by X. C. in 15 mins
I need to conditionally format a cell to highlight when date is five months out from date listed in cell and then six months out from date listed in cell.
Solved by D. J. in 16 mins
I have a column of dates expressed as months ranging from 0 to 100 from today's date in the past. I'm trying to calculate how many of these months are within the past 24 months.
Solved by V. F. in 30 mins
how do conditional format a cell to look at a fixe date in the past and conditional format a colour when the date is 18 months in the past ( amber or green if within 18 months) and 2 years or over (red )
Solved by D. L. in 23 mins
I need a formula to add 3 months to the previous cell. I have hand typed the date in i.e. 30/10/2018 not using the =date formula as i cant seem to get that to work either.