Giving days
you may need the Toolpak add in... Tools, Add Ins... Toolpak (don't need the
VBA one..)
use EDATE.
=EDATE(start date,4) will give the date 4 months from your start date. You
should be able to get the rest from there! :-)
"Kay" wrote:
I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.
I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK
|