Formula with dates

L

lara5555

Hi,

I'm trying to get column B (dates) to be a copy of column A (same date
but 1 month behind) and need to get the formula to ignore coloured cell
(weekends).. any ideas
 
R

robert111

List all weekend dates for the next 5 years in a lookup table, then tes
dates for "is this a weekend date, if so ignore it otherwise use it
 
B

Bob Phillips

Friday is a weekend in France Ardus? I always knew you were civilized <bg>

alternative

=IF(WEEKDAY(A1,2)>5,"",DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)))

Lara,

What happens when the calculated date is a weekend?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Ardus Petus said:
In B1, enter:
=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=6,"",DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)))
then copy down

HTH
Click to expand...
 
B

Bob Phillips

Really? What dates are you using, and are they real dates? I don't see that
behaviour in my spreadsheet.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top