Thread: Giving days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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