consecutive bi-monthly dates
You can use the DATE function. Inputting a 0 for the day, will result in the
last day of the previous month.
So, for example, your starting data is in A1. In A2 enter:
=IF(DAY(A1)=15,DATE(YEAR(A1),MONTH(A1)+1,0),DATE(Y EAR(A1),MONTH(A1)+1,15))
HTH,
Elkar
"dmr" wrote:
Is there a way to consecutively add bi-monthly dates to a spreadsheet? Kind
of different because the 15th will always be 15. It's the last day of the
month that changes each month. This would be for people who are paid
bi-monthly so the dates don't have to be input each time.
|