Forum

Notifications
Clear all

Show if sent date is 0-3months, 3-6months etc-

2 Posts
2 Users
0 Reactions
83 Views
(@pat)
Posts: 23
Eminent Member
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
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

I would do that with a small lookup table as demonstrated in the attached file.

 
Posted : 21/03/2024 8:48 am
Share: