Mumps.......... wat will be the excel foemula if i want due date in seperate cell......
=IF(B2<=TODAY()+3,B2-TODAY()&" days left!","").......
i was usig this formula but it calculate due date in negative to more than -3 days.......
tell 3 formula separetely.......
1st only positive (+3) due dates should be shown others should go blank (0days left, 1 day left, 2 day left, 3 day left)..........
2nd only negative (-3) due dates should be shown others should go blank(0days left, -1 day left, -2 day left, -3 day left).........
3rd both +3 and -3 due dates should show rest should go blank (0days left, 1 day left, 2 day left, 3 day left, -1 day left, -2 day left, -3 day left)..........
all other due date must go blank