•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula to calculate a two weekly date, based on another date for a certain worker
I have a scenario where one worker (z) of ten can only attend meetings on a fortnightly basis. I'd like a formula where it looks at the date in one cell [Appointment Date], returns a date 2 weeks later on a Wednesday for all other workers, unless it's worker z which then needs to fall on a specific Wednesday, based on a base date (for the sake of argument lets say going forward that would be based on 4/02/2026). So the pattern of acceptable dates for worker z going forward would be 11/02/2026 - no, 18/02/2026 - yes, 25/02/2026 - no etc.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#cloud-based spreadsheet applications
#AI formula generation techniques
#rows.com
#Excel compatibility
#appointment date
#two weekly date
#formula
#fortnightly
#Wednesday
#acceptable dates
#worker z
#meeting dates
#date calculation
#base date
#specific Wednesday
#date increment
#calendar pattern