calculate dates

[Swifey]

In my spreadsheet colT is the order date and in colY is the dispatch date. - both columns have a date format of dd/mm/yy

What I’m trying to do and failed miserably is say - if dispatch date is 48 more than the order date state "More than 48 hours delivery"

Could you please help

Thanks
Swifey

 

[Andrew Poulsom]

Something like:

=IF((Y2-T2)>2,"More than 48 hours delivery","")

 

[Swifey]

That simple I've been try Intmonth - I feel really stupid now

Thanks
Swifey

 

[Swifey]

Hi is it possible to calculate how day its over the 48 hours not taking into account weekends?

Regards
Lynda

 

[Swifey]

Hi is it possible to calculate how day its over the 48 hours not taking into account weekends?

Regards
Lynda

 

[Andrew Poulsom]

Have a look at the WORKDAY function in Help. It's in the Analysis ToolPak Add-In.

 

[Iridium]

Have a look at NETWORKDAYS in the xl help file

 

[Andrew Poulsom]

Have a look at NETWORKDAYS in the xl help file

Oops! That's what I meant really. Time to go home.

 

[Iridium]

Have a look at NETWORKDAYS in the xl help file

Oops! That's what I meant really. Time to go home.

All the help you've given me Andrew I think we'll let you off!

 

[Iridium]

Does this work?

C1=IF(NETWORKDAYS(A1,B1)>2,"More than 48 hours delivery","")

A1=order date
B1=Despatch date

HTH