Title:
Excel MT142 p2: Array Formula for Counting Dates
Video:
Description:See how to create a complex array formula that counts weekends between two dates with the SUM IF WEEKDAY ROW and INDIRECT functions in one formula See how to create an array formula that counts with date and other criteria Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions. Also see this video for another example of this date trick: Excel Magic Trick # 165: MACRO to Extract Birthdays.
Published:
28/Oct/2008
Excel MT142 p2: Array Formula for Counting Dates
Video:
Description:See how to create a complex array formula that counts weekends between two dates with the SUM IF WEEKDAY ROW and INDIRECT functions in one formula See how to create an array formula that counts with date and other criteria Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions. Also see this video for another example of this date trick: Excel Magic Trick # 165: MACRO to Extract Birthdays.
Published:
28/Oct/2008
No comments:
Post a Comment