Hi!
Totally new to the forum and I've looked for answers to my question but can't find one that works for me...
I want to format cells that have dates that are 6 months or less, but when I put in this formula =EDATE($D2,6)<TODAY(),
I get an error from Excel saying "There's a problem with this formula" and I can't figure out why! Any help would be greatly appreciated!
Totally new to the forum and I've looked for answers to my question but can't find one that works for me...
I want to format cells that have dates that are 6 months or less, but when I put in this formula =EDATE($D2,6)<TODAY(),
I get an error from Excel saying "There's a problem with this formula" and I can't figure out why! Any help would be greatly appreciated!