Need Formula for the data

[Lakshmi Narain]

Dear All,

PFA of the data. I want to find the next dispatch date form todays date. If today and dispatch date are same i want to skip and find the next dispatch date.

 

[Somendra Misra]

Hi Lakshmi,

See the file, I hope this is working as I understood your problem, blue cells has formula. Pardon me for the length of formula.

Regards,

 

[prasaddn]

Hi,

I am not able to understand the dispatch date logic. Can you explain some more. Is it always:
Dispatch Date
8-Oct-14 15-Oct-14 22-Oct-14 29-Oct-14
13-Oct-14 20-Oct-14 27-Oct-14 3-Nov-14
what if the today is after 3rd Nov?

Regards,
Prasad DN

 

[Lakshmi Narain]

Hi Lakshmi,

See the file, I hope this is working as I understood your problem, blue cells has formula. Pardon me for the length of formula.

Regards,

Thanks Somendra, Its working

 

[Somendra Misra]

You are Welcome!!!

Regards,

 

[Haseeb A]

Hello Narain,

If 'Dispatch Date' are consecutive date as shown in column C, this should work.

In I4 & copy down.

=G4+MATCH(H4,TEXT(G4+{1,2,3,4,5,6,7},"dddd"),0)

Then J4, copy down & across.

=I4+7