showing the days passed after receiving

Hi all,

I have some trouble finding a formula that will start counting from the day received or starting from 02/01/2014.
I have cases that I have 14 workdays or 5 workdays. If the letter was received at 02/01/2014 or later, it should count from that day on depending if in the column O there is TRUE (in that case 5 days, if FALSE, then 14 working days).
If the letter was received before 02/01/2014, then it should count from that date on.

No I use the formula:

Formula:

Please Login or Register  to view this content.

But I only get the count of days and does not reflect the ones needed.

It would be great to get help on this one ;-)

Greetings.

Hi all,

Before I forget, I'm using now Excel 2007 ;-)

Hi Fotis1991,,

Maby if I can illustrate it ;-)

Lets say I have column A where the date of received is inserted. In column B I have if it is a priority or not (TRUE is 5 working days to finish the case and False 14 working days to finish the case)
If I did receive a letter in the past and have the date in column A 12-DEC-2013, then I need to start counting from the 02-JAN-2014 (if it is TRUE, it should be finished on the 08-JAN-2014, if FALSE then on the 21-JAN-2014). If I receive a letter today, then it should start counting from today (also depending if TRUE or FALSE). So a letter today I need to finish if TRUE on the 10-FEB-2014 or if FALSE on the 21-FEB-2014.

I hope this is more clear now ;-)

Hi bebo021999,

I just need the count of the days, but maybe a column next to the count of days with the day would be also great to have ;-)

Greetings.

Hi Bebo021999 and Fotis1991,

Thanks for your help. I will try it later on as I don't have much time now.

Greetings.