Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
17
Views
Topic starter
Hi,
I have a proposal sent date column and on the other column, I need to show if the sent date has been 0-3months, 3-6months,6-9months or 12> months from today's date.
May I know what if formula needed for this?
Thanks in advance.
Posted : 21/03/2024 2:49 am
I would do that with a small lookup table as demonstrated in the attached file.
Posted : 21/03/2024 8:48 am