General discussion

Locked

Excel Formulas

By LF King ·
Need formula that will return previous days date when spreadsheet is opened. Can do that with =Today()-1. What I haven't been able to figure out is getting Monday to open with Friday's date. Don't want weekend dates to calculate.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Formulas

by DKlippert In reply to Excel Formulas

With the Analysis Toolpak installed try something like:
=IF(WEEKDAY(TODAY(),2)=1,TODAY()-3,TODAY()-1)
If the weekday is 1 (Monday) subtract 3 from the date, otherwise subtract 1.

Collapse -

Excel Formulas

by roc180 In reply to Excel Formulas

Use the following:

=IF(WEEKDAY(TODAY())=2,TODAY()-3,TODAY()-1)

The WEEKDAY functions checks to see if its Monday and if it is sets the date to friday.

Good Luck
Neal Martinelli

Collapse -

Excel Formulas

by LF King In reply to Excel Formulas

Thanks Neal. I got to the point where I knew I needed to combine weekday and today functions, but wasn't sure how.

Collapse -

Excel Formulas

by LF King In reply to Excel Formulas

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums