CF based on Weekdays

[ExcelRoy]

Hi all,

I am looking o use the traffic light system to show any dates in a cell the exceed the current date by 1day, 2 days and 3 days, but if no date just remain blank

Starting in K16 thru K512

I was trying =WEEKDAY(TODAY(),1)>1 but cannot seem to get this working correctly

Thanks for any help

 

[Momentman]

you should be doing something like A1-TODAY()>1 and son on, not using WEEKDAY

 

[ExcelRoy]

Hi Momentum,

Wont this count weekends?

I would like the CF to work only for working days Mon-Fri

Thanks

 

[Momentman]

Hi Momentum,

Wont this count weekends?

I would like the CF to work only for working days Mon-Fri

Thanks

It would count the weekends, you didn't state that in your original post though

=NETWORKDAYS(TODAY(),A1)>1

Assuming the dates are in A1, if your weekends are not Saturday, Sunday, you might consider using NETWORKDAYS.INTL

 

[ExcelRoy]

Perfect thanks