ExcelBanter - reference to a bimonthly date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - reference to a bimonthly date (https://www.excelbanter.com/excel-discussion-misc-queries/32156-reference-bimonthly-date.html)

thrasher

reference to a bimonthly date

I am trying to create a formula that will reference every other weekend, for
example I would like to populate a cell based on the date, but only every
other weekend.
Can anyone help with this one?

Bob Phillips

Pick a weekend start in one cell, and then use
=A1+14

etc.

--
HTH

Bob Phillips

"thrasher" wrote in message
...
I am trying to create a formula that will reference every other weekend,
for
example I would like to populate a cell based on the date, but only every
other weekend.
Can anyone help with this one?

All times are GMT +1. The time now is 04:06 PM.