Calculating Calendar Days

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Is there a function to calculate a calendar date before or
after as specified start date? I know the function
WORKDAY, but I need one that takes into consideration all
days. Ex. 4/1/04 +60 days = 5/31/04

Thank you
 
Hi Glenn

AFAIK you can do this with a simple formula

A1 has your date
B1 has the number of days before or after the date
in C1
=A1 + B1
should give you what you're looking for,

let us know how you go

Cheers
JulieD
 
Julie/Frank,

I couldn't see the forest for the trees...trying to make
it more difficult than it actually is.
That works. Thank you both.

Glenn
 
Back
Top