CF Formula with dates

[ExcelRoy]

Hi all,

I am trying to modify the following formula to have the CF show when the date in M13 is within 10 working days of (Today)


=AND(LEN($M13),TODAY()+3=$M13)

Any help appreciated

Thanks

 

[JoeMo]

Maybe:

=AND(LEN($M13),ABS($M13-TODAY())<=10)

 

[Scott T]

Add any other conditions to the and formula

=AND(M13<=TODAY()+10,M13>=TODAY()-10)

 

[Joe4]

when the date in M13 is within 10 working days of (Today)

Is that 10 days BEFORE or AFTER today?

If either of those two, that AND clause would look something like this:

ABS(WORKDAY($M13,10)-TODAY())) < 10

If you are only going one way, then you may be able to use NETWORKDAY.

Have a look at those functions:
https://support.office.com/en-ie/article/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33
https://support.office.com/en-us/article/networkdays-function-48e717bf-a7a3-495f-969e-5005e3eb18e7

 

[ExcelRoy]

Perfect thanks all

I went with JoMoe's solution

many thanks

 

[Joe4]

I went with JoMoe's solution

Note that just does 10 straight days.
I thought you said working days, which would imply you do not want weekends.
If that really is the case, you are going to need to use a solution with either the WORKDAY or NETWORKDAYS function.