View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Calendar, if paid on date, not count prior

Its possible. Without knowing exactly how your formulas are setup, my help is
limited, but I would suggest looking at the WEEKDAY function for a way to
determine if a date is Monday or Tuesday.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jake F" wrote:

I'm trying to track time spent on a monthly calendar in excel. I need to
create function to total the hours each week and then those are totaled by
month. If the hours are paid on wednesday, is there a way to not calculate
the hours for monday and tuesday? This is probably more work to setup than
will save me time, but now that the question is in my head I need to know if
it's possible.