Link to home
Create AccountLog in
Avatar of David Bigelow
David BigelowFlag for United States of America

asked on

How to calculate the nth day of the month, or the preceeding weekday if nth day is on weekend.

For Excel, what is a formula for calculating the 25th day of the month, or the weekday before the 25th if it falls on a weekend day? I'll be using a date reference cell of H4.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of David Bigelow

ASKER

Hi byundt,
Thank you for your help. The first formula is exactly what I needed.