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.
|