I get paid on the 15th if it's a workday or on the last workday before the 15th if the 15th of the month falls on a weekend. I have a series of data on column a with the days of 15 in consecutive months.
Is there a formula to return, for example for February the 13th of February because it falls on a Friday while the 15th is a Sunday?
I heard of the WORKDAY function but I just can't seem to get it to work.
A
1 15/01/2015
2 15/02/2015
3 15/03/2015
4 15/04/2015
Thanks.
Bookmarks