Equation

J

J

Hi,

I would like to know how to set below equation?

- to set a formula which to reflect the 28th day of every month, but if the
28th of the month is not a weekday, then pls set it to the previous Friday.

Thanks in advance.

e.g. 2009/10/28, 2009/11/27
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with a date formula 3
Referencing cells 1
Last day of month in query 15
Function to set Date 1
Search closest day in the past from today 2
day of the week and date formula 2
COUPNCD & Bond pricing 0
Find then highlight in yellow 6

Top