Hello,
I want a function that format a cell with a color if a specific day is less than one month from today.
i.e; if today is 30 days or less far away from a certain day then give me a cell format.
Best regards
Hello,
I want a function that format a cell with a color if a specific day is less than one month from today.
i.e; if today is 30 days or less far away from a certain day then give me a cell format.
Best regards
=(TODAY()+30>A1)
where A1 is a date
format as required
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks