Google Spreadsheet Post #2511
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Sep-09-2018
question by: Russ Walker 7
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/MeIq1I8-QWg;context-place=forum/docs
How to enter a date that has to be on a weekday.
Hi, I want to enter the 6th of the month into a cell unless the 6th falls on a weekend (saturday or Sunday) then I want the date in the cell to be the Friday before the 6th. The formula I have managed so far moves the date forwards to a Monday and not back to the Friday, is anyone good with date formulas. Col I is the col with the formula and col A is just for Col I to get the initial date from. Any help will be greatley appreciated.
No comments:
Post a Comment