Calculate Date
Hi
if you have the analysis toolpak installed (tools / addins / analysis
toolpak) you can use the WORKDAY function
e.g.
=WORKDAY(A2,-35)
Cheers
JulieD
"Jerome" wrote in message
...
I am trying to create a formula that will take a specific date in a cell
and
give the date 35 days prior. I am only concerned with Mon-Fri. So, if
the
date falls on a Saturday then give the Friday date. If the date falls on
a
Sunday, then give the Monday date. I am not sure where to begin. I wrote
the following function of "= A2 - 32" Any help is greatly appreciated.
|